C#代码
- protected void bind()
- {
- SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["pubsConnectionString"].ConnectionString);
- SqlDataAdapter sda = new SqlDataAdapter("select * from authors", conn);
- DataSet ds = new DataSet();
- sda.Fill(ds, "authors");
- GridView1.DataSource = ds.Tables["authors"];
- GridView1.AllowPaging = true;
- GridView1.PageSize = 5;
- GridView1.DataBind();
- if (GridView1.PageIndex == 0)
- {
- Button1.Enabled = false;
- Button2.Enabled = false;
- }
- else
- {
- Button1.Enabled = true;
- Button2.Enabled = true;
- }
- if (GridView1.PageIndex == GridView1.PageCount - 1)
- {
- Button3.Enabled = false;
- Button4.Enabled = false;
- }
- else
- {
- Button3.Enabled = true;
- Button4.Enabled = true;
- }
- }
- protected void Button1_Click(object sender, EventArgs e)
- {
- switch (((Button)sender).CommandArgument.ToString())
- {
- case "first":
- GridView1.PageIndex = 0;
- break;
- case "prev":
- GridView1.PageIndex = GridView1.PageIndex - 1;
- break;
- case "next":
- GridView1.PageIndex = GridView1.PageIndex + 1;
- break;
- case "last":
- GridView1.PageIndex = GridView1.PageCount - 1;
- break;
- }
- bind();
- }
