SQLDataAdapter + GridView + Paging + PageIndexChanging 使用方法

 
SQLDataAdapter + GridView + Paging + PageIndexChanging 使用方法
 

   WebForm1.aspx
 
   <form id="form1" runat="server">
   <div>
      <asp:GridView runat="server" ID="GD1"
      AllowPaging="true" PageIndex="0" PageSize="3" />
   </div>
   </form>
 

 

   WebForm1.aspx.cs
 
   using System;
   using System.Web.UI.WebControls;
   using System.Data;
   using System.Data.SqlClient;
   using System.Text;
 
   namespace WebApplication34
   {
      public partial class WebForm1 : System.Web.UI.Page
      {
         protected void Page_Load(object sender, EventArgs e)
         {
            if (!Page.IsPostBack) GetData();
            GD1.PageIndexChanging += new GridViewPageEventHandler(GD1_PageIndexChanging);
         }
 
         void GD1_PageIndexChanging(object sender, GridViewPageEventArgs e)
         {
            GD1.PageIndex = e.NewPageIndex;
            GetData();
         }
 
         private void GetData()
         {
            SqlConnection con1 = new SqlConnection("Data Source=.\\Express; Initial Catalog=Soccer; Integrated Security=SSPI");
            con1.Open();
 
            StringBuilder sb = new StringBuilder();
            sb.Append("SELECT * FROM dbo.Team;");
 
            SqlDataAdapter Adapter = new SqlDataAdapter(sb.ToString(), con1);
            DataSet ds = new DataSet();
 
            Adapter.Fill(ds);
 
            GD1.DataSource = ds.Tables[0];
            GD1.DataBind();
 
            con1.Close();
            con1.Dispose();
         }
      }
   }