DataGrid同时具有分页和排序功能及注意点

【 tulaoshi.com - ASP.NET 】

当DataGrid同时具有分页和排序功能时应注意在重新绑定数据源时，MyDataGrid.CurrentPageIndex=0;
下面给实现以上功能的原码，也就不多缀了aspx中包含有DataGrid和控制其数据源变化的dropdownlist
DataGrid代码
  <asp:datagrid id="MyDataGrid" runat="server" BorderColor="#CCCCCC" Font-Size="100%" HorizontalAlign="Center"
            AutoGenerateColumns="False" OnDeleteCommand="MyDataGrid_Delete" OnSortCommand="Sort_Grid" OnPageIndexChanged="MyDataGrid_PageIndexChanged"
            DataKeyField="ACC_NO" PagerStyle-Position="Bottom" PagerStyle-HorizontalAlign="Center" PagerStyle-Mode="NextPrev"
            PageSize="10" AllowSorting="True" AllowPaging="True" CellPadding="4" Width="100%"
            <AlternatingItemStyle BackColor="#E9E9E6"</AlternatingItemStyle
            <HeaderStyle Font-Bold="True" Wrap="False" ForeColor="White" BackColor="#999999"</HeaderStyle
            <Columns
             <asp:ButtonColumn Text="口" CommandName="Delete"</asp:ButtonColumn
             <asp:BoundColumn DataField="NO" SortExpression="NO" ReadOnly="True" HeaderText="序号"</asp:BoundColumn
             <asp:BoundColumn DataField="ID" SortExpression="ID" HeaderText="ID"</asp:BoundColumn
             <asp:BoundColumn DataField="NAME" SortExpression="NAME" HeaderText="名称"</asp:BoundColumn
             <asp:BoundColumn DataField="C_NAME" SortExpression="C_NAME" HeaderText="各科名称"</asp:BoundColumn
             <asp:BoundColumn DataField="FLG" SortExpression="FLG" HeaderText="项目"</asp:BoundColumn
            </Columns
            <PagerStyle NextPageText="下10件" PrevPageText="返回" HorizontalAlign="Center"</PagerStyle
           </asp:datagrid

dropdownlist代码
<asp:dropdownlist id="ddlWk" Runat="server" AutoPostBack="True" Enabled="False"
               <asp:ListItem Value="0"东京</asp:ListItem
               <asp:ListItem Value="3"九州</asp:ListItem
               <asp:ListItem Value="8"北海道</asp:ListItem
               <asp:ListItem Value="9"四国</asp:ListItem
              </asp:dropdownlist

（本文来源于图老师网站，更多请访问https://www.tulaoshi.com）

 

（本文来源于图老师网站，更多请访问https://www.tulaoshi.com）

aspx.cs文件代码核心如下：
private void Page_Load(object sender, System.EventArgs e)
  {
   if(!IsPostBack)
   {
       Session["WP"] ="0";
       ddlWk_getS();
       BindGrid();
   } 
  }
  private void ddlWk_getS()
  {
   switch (Session["WP"].ToString())
   {
    case "0":ddlWk.SelectedIndex=0;
     break;
 &nb