自定义DataGrid分页设置

最新推荐文章于 2020-11-28 03:46:28 发布

fzzf

最新推荐文章于 2020-11-28 03:46:28 发布

阅读量739

点赞数

分类专栏： Asp.Net 文章标签： datagrid asp server dataset textbox object

本文链接：https://blog.csdn.net/fzzf/article/details/528426

版权

Asp.Net 专栏收录该内容

55 篇文章 0 订阅

订阅专栏

先定义ASPX页面，注意AllowCustomPaging要设为"False"：
<body>
  <form id="DictList" method="post" runat="server">
      <TABLE style="BORDER-COLLAPSE: collapse" cellSpacing="0" width="100%" border="1">
    <TR>
     <td bgColor="#c0c000">信息：<FONT face="Arial" color="#ffffff">数据维护</FONT>
     </td>
    </TR>
    <tr>
     <td><FONT face="宋体"></FONT></td>
    </tr>
    <tr>
     <td><asp:datagrid id="MyDataGrid" runat="server" Width="100%" PageSize="20" AllowPaging="True" AutoGenerateColumns="False" DataKeyField="FDictid">
       <SelectedItemStyle BackColor="#FFC080"></SelectedItemStyle>
       <HeaderStyle BackColor="#C0C000"></HeaderStyle>
       <Columns>
        <asp:ButtonColumn Text="选择" HeaderText="选择" CommandName="Select">
         <HeaderStyle Font-Bold="True" HorizontalAlign="Center" Width="8%"></HeaderStyle>
         <ItemStyle Font-Bold="True" HorizontalAlign="Center"></ItemStyle>
        </asp:ButtonColumn>
        <asp:BoundColumn DataField="FDictID" SortExpression="FDictID asc" HeaderText="标识号">
         <HeaderStyle Width="15%"></HeaderStyle>
        </asp:BoundColumn>
        <asp:BoundColumn DataField="FNameCn" SortExpression="FNameCn asc" HeaderText="名称">
         <HeaderStyle Width="15%"></HeaderStyle>
        </asp:BoundColumn>
        <asp:BoundColumn DataField="FNameEn" SortExpression="FNameEn asc" HeaderText="英文名称">
         <HeaderStyle Width="15%"></HeaderStyle>
        </asp:BoundColumn>
        <asp:BoundColumn DataField="FNote" SortExpression="FNote asc" HeaderText="描叙">
         <HeaderStyle Width="47%"></HeaderStyle>
        </asp:BoundColumn>
       </Columns>
       <PagerStyle Visible="False"></PagerStyle>
      </asp:datagrid></td>
    </tr>
   </TABLE>
   <TABLE style="BORDER-COLLAPSE: collapse" cellSpacing="0" width="100%" bgColor="#ff9966" border="1">
    <TR>
     <td align="right"><asp:linkbutton id="btnFirst" runat="server" CommandArgument="fist">首页</asp:linkbutton>  
      <asp:linkbutton id="btnPrev" runat="server" Width="36px" CommandArgument="prev">上一页</asp:linkbutton>  
      <asp:linkbutton id="btnNext" runat="server" CommandArgument="next">下一页</asp:linkbutton>  
      <asp:linkbutton id="btnLast" runat="server" CommandArgument="last">末页</asp:linkbutton>  
      <asp:label id="lblCurrentIndex" runat="server"></asp:label>/<asp:label id="lblPageCount" runat="server"></asp:label>  
      跳转到<asp:TextBox id="txtGoPage" runat="server" Width="30px" CssClass="textbox"></asp:TextBox>
      <asp:Button id="btnGo" runat="server" Text="GO" CssClass="button" Width="29px"></asp:Button></td>
    </TR>
   </TABLE>
  </form>

codebehind主要功能部分代码：

  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnString"]);

   if (!IsPostBack)
    BindGrid();
  }

  public void BindGrid()
  {
   string strSql ="SELECT * FROM t_dict ";
   SqlDataAdapter myCommand = new SqlDataAdapter(strSql, myConnection);
   DataSet ds = new DataSet();
   myCommand.Fill(ds, "t_dict");
   MyDataGrid.DataSource=ds.Tables["t_dict"].DefaultView;
   MyDataGrid.DataBind();
   ShowStatsPage();
  }

  private void PagerButtonClick(object sender, System.EventArgs e)
  {
   //获得LinkButton的参数值
   String arg = ((LinkButton)sender).CommandArgument;

   switch(arg)
   {
    case ("next"):
     if (MyDataGrid.CurrentPageIndex < (MyDataGrid.PageCount - 1))
      MyDataGrid.CurrentPageIndex ++;
     break;
    case ("prev"):
     if (MyDataGrid.CurrentPageIndex > 0)
      MyDataGrid.CurrentPageIndex --;
     break;
    case ("fist"):
     MyDataGrid.CurrentPageIndex=0;
     break;
    case ("last"):
     MyDataGrid.CurrentPageIndex = (MyDataGrid.PageCount - 1);
     break;
    default:
     //本页值
     MyDataGrid.CurrentPageIndex = Convert.ToInt32(arg);
     break;
   }
   BindGrid();
  }

  void ShowStatsPage()
  {
   //显示页面信息
   lblCurrentIndex.Text = "[<font color="blue">当前为第：" + ((int)MyDataGrid.CurrentPageIndex+1) + "页</font>]";
   lblPageCount.Text = "[<font color="blue">共：" + MyDataGrid.PageCount + "页</font>]";
  }

  private void MyDataGrid_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
  {
   //处理按下数字的方法
   MyDataGrid.CurrentPageIndex = e.NewPageIndex;
   BindGrid();
  }

  private void btnGo_Click(object sender, System.EventArgs e)
  {
   //页面直接跳转的代码
   if(txtGoPage.Text.Trim()!="")
   {
    int PageI=Int32.Parse(txtGoPage.Text.Trim())-1;
    if (PageI >=0 && PageI < (MyDataGrid.PageCount))
     MyDataGrid.CurrentPageIndex = PageI ;
   }
   BindGrid();
  }