1protected 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
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