dataGuid數據綁定及其分頁

private void Page_Load(object sender, System.EventArgs e)
  {
   if(!Page.IsPostBack)
   {
    this.DGBind();
   }

//  
//   SqlConnection con=DB.CreateDB();
//   SqlCommand cmd=new SqlCommand("select * from new",con);
//   con.Open();
//   SqlDataAdapter sda=new SqlDataAdapter();
//   sda.SelectCommand=new SqlCommand("select * from news",con);
//   DataSet ds=new DataSet();
//         sda.Fill(ds,"emp");
//   this.DG.DataSource=ds.Tables["emp"];
//   this.DG.DataBind();
  }

  #region Web Form 設計工具產生的程式碼
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: 此為 ASP.NET Web Form 設計工具所需的呼叫。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  
  /// <summary>
  /// 此為設計工具支援所必須的方法 - 請勿使用程式碼編輯器修改
  /// 這個方法的內容。
  /// </summary>
  private void InitializeComponent()
  {   
   this.DG.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DG_PageIndexChanged);
   this.DG.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged);
   this.Load += new System.EventHandler(this.Page_Load);

  }
  #endregion
  private void DGBind()
  {
               SqlConnection con=DB.CreateDB();
      SqlCommand cmd=new SqlCommand("select * from news order by Newstime desc",con);
      con.Open();
      SqlDataAdapter sda=new SqlDataAdapter(cmd);
      DataSet ds=new DataSet();
            sda.Fill(ds,"emp");
      this.DG.DataSource=ds.Tables["emp"];
      this.DG.DataBind();
  }

private void DG_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
  {
  this.DG.CurrentPageIndex=e.NewPageIndex;
  this.DGBind();
  }