c#中,查询之后的数据是多页显示,当点击第二页之后数据就回到了原始数据
下面是分页显示的代码//分页显示
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
try
{
GridView1.PageIndex = e.NewPageIndex;
switch (i)
{
case 1:
{
string sql = "select room.room_id 房间编号,unit.unit_name 单元名称, room.room_name 房间名称,unit.unit_id 单元编号,room.low_income 是否低保户,room.house_door 是否保障户,room.ifrent 是否出租,building.build_id 楼编号,building.build_name 楼名称,yard.yard_id 家属院编号,yard.yard_name 家属院名称 " +
"FROM community INNER JOIN yard ON community.community_id = yard.community_id INNER JOIN building ON yard.yard_id = building.yard_id INNER JOIN unit ON building.build_id = unit.build_id INNER JOIN room ON unit.unit_id = room.unit_id where low_income ='" + this.DropDownList6.Text + "'" + "and community.community_id='" + this.DropDownList3.Text + "'";
DataSet ds = db.GetDataSet(sql, "room");
GridView1.DataSource = ds.Tables["room"];
GridView1.DataBind();
break;
}
case 2:
{
string sql = "select room.room_id 房间编号, room.room_name 房间名称,room.low_income 是否低保户,room.house_door 是否保障户,room.ifrent 是否出租,building.build_id 楼编号,building.build_name 楼名称,yard.yard_id 家属院编号,yard.yard_name 家属院名称,unit.unit_id 单元编号,unit.unit_name 单元名称 " +
"FROM community INNER JOIN yard ON community.community_id = yard.community_id INNER JOIN building ON yard.yard_id = building.yard_id INNER JOIN unit ON building.build_id = unit.build_id INNER JOIN room ON unit.unit_id = room.unit_id where house_door like '%" + this.DropDownList7.Text + "%'" + "and community.community_id='" + this.DropDownList3.Text + "'";
DataSet ds = db.GetDataSet(sql, "room");
GridView1.DataSource = ds.Tables["room"];
GridView1.DataBind();
break;
}
case 3:
{
string sql = "select room.room_id 房间编号, room.room_name 房间名称,room.low_income 是否低保户,room.house_door 是否保障户,room.ifrent 是否出租,building.build_id 楼编号,building.build_name 楼名称,yard.yard_id 家属院编号,yard.yard_name 家属院名称,unit.unit_id 单元编号,unit.unit_name 单元名称 " +
"FROM yard INNER JOIN building ON yard.yard_id = building.yard_id INNER JOIN unit ON building.build_id = unit.build_id INNER JOIN room ON unit.unit_id = room.unit_id where low_income like '%" + this.DropDownList9.Text + "%'" + "and yard.yard_id='" + this.DropDownList4.Text + "'";
DataSet ds = db.GetDataSet(sql, "room");
GridView1.DataSource = ds.Tables["room"];
GridView1.DataBind();
break;
}
case 4:
{
string sql = "select room.room_id 房间编号, room.room_name 房间名称,room.low_income 是否低保户,room.house_door 是否保障户,room.ifrent 是否出租,building.build_id 楼编号,building.build_name 楼名称,yard.yard_id 家属院编号,yard.yard_name 家属院名称,unit.unit_id 单元编号,unit.unit_name 单元名称 " +
"FROM yard INNER JOIN building ON yard.yard_id = building.yard_id INNER JOIN unit ON building.build_id = unit.build_id INNER JOIN room ON unit.unit_id = room.unit_id where house_door like '%" + this.DropDownList10.Text + "%'" + "and yard.yard_id='" + this.DropDownList4.Text + "'";
DataSet ds = db.GetDataSet(sql, "room");
GridView1.DataSource = ds.Tables["room"];
GridView1.DataBind();
break;
}
case 5:
{
Button1_Click();
//string sql = "select room.room_id 房间编号, room.room_name 房间名称,room.low_income 是否低保户,room.house_door 是否保障户,room.ifrent 是否出租,building.build_id 楼编号,building.build_name 楼名称,yard.yard_id 家属院编号,yard.yard_name 家属院名称,unit.unit_id 单元编号,unit.unit_name 单元名称 " +
// "FROM yard INNER JOIN building ON yard.yard_id = building.yard_id INNER JOIN unit ON building.build_id = unit.build_id INNER JOIN room ON unit.unit_id = room.unit_id where low_income='" + this.DropDownList1.Text + "'" + "and building.build_id='" + this.DropDownList5.Text + "'";
//DataSet ds = db.GetDataSet(sql, "room");
//GridView1.DataSource = ds.Tables["room"];
//GridView1.DataBind();
break;
}
case 6:
{
string sql = "select room.room_id 房间编号, room.room_name 房间名称,room.low_income 是否低保户,room.house_door 是否保障户,room.ifrent 是否出租,building.build_id 楼编号,building.build_name 楼名称,yard.yard_id 家属院编号,yard.yard_name 家属院名称,unit.unit_id 单元编号,unit.unit_name 单元名称 " +
"FROM yard INNER JOIN building ON yard.yard_id = building.yard_id INNER JOIN unit ON building.build_id = unit.build_id INNER JOIN room ON unit.unit_id = room.unit_id where house_door like '%" + this.DropDownList2.Text + "%'" + "and building.build_id='" + this.DropDownList5.Text + "'";
DataSet ds = db.GetDataSet(sql, "room");
GridView1.DataSource = ds.Tables["room"];
GridView1.DataBind();
break;
}
default:
SetDataBinder();
break;
}
}
catch
{
Response.Write(db.MessageBox("出错!!!!"));
}
} --------------------编程问答-------------------- aspnetpager分页控件
if(!ISPostBack)
{
//绑定数据
} --------------------编程问答--------------------
LZ这代码乱的,其实你可以把绑定数据放进一个方法,GridView1_PageIndexChanging事件再调用就行了 --------------------编程问答-------------------- 你的分页序号,是不是没有用一些类似ViewState的东西来记录和维持?分页的控件是否指定了样式和触发了事件? --------------------编程问答-------------------- 重复代码太多 相同的可以提取出来 --------------------编程问答-------------------- 天啊。。。。你这代码看着难道不蛋疼吗 --------------------编程问答-------------------- 为什么这样写 啊,感觉很冗余啊 --------------------编程问答-------------------- 数据库绑定的问题,你分页部分的绑定肯定和你初始绑定不一致。 --------------------编程问答-------------------- 第一次看见这么 做分页的,
1.用 GridView 的自己的分页 功能,直接 e.NewPageIndex 就OK
2.用SQL 的Row_Number 来 对页码查询 数据。
补充:.NET技术 , ASP.NET