自定义DataGrid分页设置

关注

原创最新推荐文章于 2021-02-16 02:55:23 发布 858 阅读 AI 写同款· GEO 优化 ›

FPGA实战：手把手教你实现VESA DSC编码（附Verilog代码解析）本文详细介绍了如何使用FPGA实现VESA DSC编码器，包括核心架构设计、Verilog代码实现与优化技巧。通过流水线设计、色彩空间转换和预测编码等关键技术，帮助开发者掌握工业级DSC编码器的开发流程，并提供实用的调试与性能优化方法。阅读详情

自定义DataGrid分页设置

源作者：追风人气：13974

　　这里我实现了DataGrid的个性化分页，现在把代码贴出来朋友们参考，同时在这个功能的实现过程，参考了“飞刀”从国外翻译的一篇文章。

　　先定义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();
}
//----------------------翻页代码结束