[转载]实现GridView手动设定分页
先在属性界面中GridView中设置AllowPaging="True"
这样就可以显示手动分页了 。
转自:http://www.banysky.com/blog/article.asp?id=38
1
protected void Page_Load(object sender, EventArgs e)
2
{
3
string keyword=Request["keyword"];
4
SqlConnection con = db.createConnection();
5
con.Open();
6
DataSet ds = new DataSet();
7
SqlDataAdapter sdr = new SqlDataAdapter();
8
sdr.SelectCommand = new SqlCommand("select * from ipaddress where ip like'%" + keyword + "%'", con);
9
sdr.Fill(ds);
10
GridView1.DataSource = ds;
11
ds.Dispose();
12
con.Close();
13
GridView1.DataBind();
14
15
}
16![]()
17
//给行增加颜色
18
protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
19
{
20
if (e.Row.RowType == DataControlRowType.DataRow)
21
{
22
e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#3399FF';");
23
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c;");
24
}
25
}
26![]()
27![]()
28
//GridView有一个PageIndexChanging事件
29
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
30
{
31
this.GridView1.PageIndex = e.NewPageIndex;
32
this.GridView1.DataBind();
33
}
34![]()
protected void Page_Load(object sender, EventArgs e)2
{3
string keyword=Request["keyword"];4
SqlConnection con = db.createConnection();5
con.Open();6
DataSet ds = new DataSet();7
SqlDataAdapter sdr = new SqlDataAdapter();8
sdr.SelectCommand = new SqlCommand("select * from ipaddress where ip like'%" + keyword + "%'", con);9
sdr.Fill(ds);10
GridView1.DataSource = ds;11
ds.Dispose();12
con.Close();13
GridView1.DataBind();14
15
}16

17
//给行增加颜色18
protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)19
{20
if (e.Row.RowType == DataControlRowType.DataRow)21
{22
e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#3399FF';");23
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c;");24
}25
}26

27

28
//GridView有一个PageIndexChanging事件29
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)30
{31
this.GridView1.PageIndex = e.NewPageIndex;32
this.GridView1.DataBind();33
}34

这样就可以显示手动分页了 。
转自:http://www.banysky.com/blog/article.asp?id=38

浙公网安备 33010602011771号