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

    当DataGrid同时具有分页和排序功能时应注意在重新绑定数据源时，MyDataGrid.CurrentPageIndex=0;
下面给实现以上功能的原码，也就不多缀了aspx中包含有DataGrid和控制其数据源变化的dropdownlist
DataGrid代码
              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" >
           
           
           
            
            
            
            
            
            
           
           
          

dropdownlist代码

               东京
               九州
               北海道
               四国
             

 

aspx.cs文件代码核心如下：
private void Page_Load(object sender, System.EventArgs e)
  &＃123;
   if(!IsPostBack)
   &＃123;
       Session["WP"] ="0";
       ddlWk_getS();
       BindGrid();
   &＃125; 
  &＃125;
  private void ddlWk_getS()
  &＃123;
   switch (Session["WP"].ToString())
   &＃123;
    case "0":ddlWk.SelectedIndex=0;
     break;
    case "3":ddlWk.SelectedIndex=1;
     break;
    case "8":ddlWk.SelectedIndex=2;
     break;
    case "9":ddlWk.SelectedIndex=3;
     break;
    default:ddlWk.SelectedIndex=0;
     break;
   &＃125;
  &＃125;
  protected void BindGrid()
  &＃123;
   MyDataGrid.DataSource=GetData().Tables["vCO"].DefaultView;
   MyDataGrid.DataBind();
   //COUNT.Text=MyDataGrid.Columns.Count.ToString();
  &＃125;

  ///

  /// 返回Data
  ///

  ///
  private DataSet GetData()
  &＃123;
   string strCOnn=(String) ((NameValueCollection) Context.GetConfig("system.web/database"))["strConn"];
   using (SqlConnection cOnn= new SqlConnection(strConn))
   &＃123;
    SqlCommand cmd = new SqlCommand("sp_C",conn);
    cmd.CommandType=CommandType.StoredProcedure;
    cmd.Parameters.Add("@place",SqlDbType.VarChar,2);
    cmd.Parameters["@place"].Value=Session["WP"].ToString();
    conn.Open();

    SqlDataAdapter da = new SqlDataAdapter();
    da.SelectCommand=cmd;
    DataSet ds=new DataSet();
    da.Fill(ds,"vCO");
    Count.Text="ヒット："+ds.Tables["vCO"].Rows.Count.ToString()+"件";
    return ds;
   &＃125;

  &＃125;
  ///

  ///从DataSet中除一
  ///

  ///
  ///
  protected void MyDataGrid_Delete(Object sender, DataGridCommandEventArgs E)
  &＃123;
    String strID=MyDataGrid.DataKeys[(int)E.Item.ItemIndex].ToString();
    //删除操作
  &＃125;
  ///

  /// 分页操作
  ///

  ///
  ///
  protected void MyDataGrid_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
  &＃123;
   MyDataGrid.CurrentPageIndex=e.NewPageIndex;
   BindGrid();
  &＃125;
  ///

  /// 排序
  ///

  ///
  ///
  protected void Sort_Grid(object sender, DataGridSortCommandEventArgs e)
  &＃123;
   DataView dv= new DataView(GetData().Tables["vCO"]);
   dv.Sort= e.SortExpression.ToString();
   MyDataGrid.DataSource=dv;
   MyDataGrid.DataBind();
  &＃125;

  #region Web   override protected void OnInit(EventArgs e)
  &＃123;
   //   //
   InitializeComponent();
   base.OnInit(e);
  &＃125;

  ///

  ///

  private void InitializeComponent()
  &＃123;   
   this.ddlWk.SelectedIndexChanged += new System.EventHandler(this.ddlWk_SelectedIndexChanged);
   this.Load += new System.EventHandler(this.Page_Load);

  &＃125;
  #endregion

  private void ddlWk_SelectedIndexChanged(object sender, System.EventArgs e)
  &＃123;
   Session["WP"]=ddlWk.SelectedValue;
   MyDataGrid.CurrentPageIndex=0;//没有这一句，当该页码超出其他数据源的范围时会出错
   BindGrid();
   Response.Write( "");

  &＃125;