Gridview的分頁功能

 

先在 Page_Load

 protected void Page_Load(object sender, EventArgs e)
    {   

        if (!Page.IsPostBack)
        {

          // Ado.NET 的副程式
            BindGridView();
    
        }
    }

  protected void gvNewsList_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvNewsList.PageIndex =  e.NewPageIndex;
        BindGridView();
    }
    public void BindGridView()
    {        
        DataSet dsData = New DataSet() ; // 這邊就是你叫資料的給 DataTable or Dataset 的程式

         SqlDataAdapter sqlDA = new SqlDataAdapter(strCmd, sqlConn);
        sqlDA.Fill(dsData, "Data");

        gvNewsList.DataSource = dsData.Table["Data"];
        gvNewsList.DataBind();
    }