gridView分页

<tr>
                     <td align="center" style="height: 25px">
                         <asp:LinkButton ID="btnFirst" CommandArgument="first" OnClick="PagerButtonClick"
                             runat="server">
</asp:LinkButton>
                         <asp:LinkButton ID="btnPrev" CommandArgument="prev" OnClick="PagerButtonClick" runat="server">
上一页</asp:LinkButton>
                         <asp:LinkButton ID="btnNext" CommandArgument="next" OnClick="PagerButtonClick" runat="server">
下一页</asp:LinkButton>
                         <asp:LinkButton ID="btnLast" CommandArgument="last" OnClick="PagerButtonClick" runat="server">
</asp:LinkButton>
                         <asp:Label ID="LblCurrentIndex" runat="server"></asp:Label>
                         <asp:Label ID="LblPageCount" runat="server"></asp:Label>
                         <asp:Label ID="LblRecordCount" runat="server"></asp:Label></td>
                 </tr>
                 <tr>
                     <td>
                         <asp:Button ID="Button2" runat="server" Text="checkbox
得到选择的行" OnClick="Button2_Click">
                         </asp:Button>
                         <asp:Button ID="Button1" runat="server" Text="radio
得到选择的行" OnClick="Button1_Click"></asp:Button>
                     </td>
                 </tr>

private void GridViewBind(string Sqlsort)
     {
         string connStr = ConfigurationManager.ConnectionStrings["ConnString1"].ConnectionString;
         string SqlStr = "Select * FROM test01 where id<1000" + Sqlsort;
         DataSet ds = new DataSet();
        
         try
         {
             SqlConnection conn = new SqlConnection(connStr);
             if (conn.State.ToString() == "Closed") conn.Open();

             SqlDataAdapter da = new SqlDataAdapter(SqlStr, conn);
             da.Fill(ds, "test01");            
             if (conn.State.ToString() == "Open") conn.Close();

             GridView1.DataSource = ds.Tables[0].DefaultView;
             GridView1.DataBind();

             LblCurrentIndex.Text = "
" + (GridView1.PageIndex + 1).ToString() + " ";
             LblPageCount.Text = "
" + GridView1 .PageCount.ToString()+ " ";
             LblRecordCount.Text = "
总共 "+ds.Tables[0].Rows.Count.ToString()+" ";
             if (ds.Tables[0].Rows.Count == 0)
             {
                 btnFirst.Visible = false;
                 btnPrev.Visible = false;
                 btnNext.Visible = false;
                 btnLast.Visible = false;

                 LblCurrentIndex.Visible = false;
                 LblPageCount.Visible = false;
                 LblRecordCount.Visible = false;
             }
             else if (GridView1.PageCount == 1)
             {
                 btnFirst.Visible = false;
                 btnPrev.Visible = false;
                 btnNext.Visible = false;
                 btnLast.Visible = false;
             }
//QQ:272912705 光之翼 www.hi.baidu.com/jcomet
             //
计算生成分页页码,分别为:" " "上一页" "下一页" " "
             btnFirst.CommandName = "1";
             btnPrev.CommandName = (GridView1.PageIndex == 0 ? "1" : GridView1.PageIndex.ToString());

             btnNext.CommandName = (GridView1.PageCount == 1 ? GridView1.PageCount.ToString() : (GridView1.PageIndex + 2).ToString());
             btnLast.CommandName = GridView1.PageCount.ToString();
             //
         }
         catch(Exception ex)
         {
             Response.Write("
数据库错误,错误原因:"+ex.Message);
             Response.End();
         }
     }
     protected void PagerButtonClick(object sender, EventArgs e)
     {
         GridView1.PageIndex = Convert.ToInt32(((LinkButton)sender).CommandName)-1;
         GridViewBind("");        
     }

     protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
     {
         e.Row.Attributes["onmouseover"] = "ItemOver(this)";
     }

原文地址:https://www.cnblogs.com/jcomet/p/1242478.html