302班

 public class SelAndDropAll : System.Web.UI.Page
 {
  protected System.Web.UI.WebControls.Button btnDelete;
  protected System.Web.UI.WebControls.DataGrid dgShow;
 
  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此處放置用戶代碼以初始化頁面
   //添加確認刪除事件
   btnDelete.Attributes.Add("onclick", "return confirm('您真的要刪除所選項嗎？');");
   if(!IsPostBack)
    BindData();
   
  }
  //初始化綁定
  private void BindData()
  {
   string strCon = System.Configuration.ConfigurationSettings.AppSettings["DSN"];
   SqlConnection con = new SqlConnection(strCon);
   SqlDataAdapter da = new SqlDataAdapter("Select * from tbStudentinfo",con);
   DataSet ds = new DataSet();
   da.Fill(ds,"studentinfo");
   dgShow.DataSource = ds.Tables["studentinfo"].DefaultView;
   dgShow.DataBind();
  }
  #region Web Form Designer generated code
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN：該調用是 ASP.NET Web 窗體設計器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  
  /// <summary>
  /// 設計器支持所需的方法 - 不要使用代碼編輯器修改
  /// 此方法的內容。
  /// </summary>
  private void InitializeComponent()
  {   
   this.dgShow.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.dgShow_PageIndexChanged);
   this.dgShow.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgShow_CancelCommand);
   this.dgShow.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgShow_EditCommand);
   this.dgShow.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgShow_UpdateCommand);
   this.dgShow.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgShow_DeleteCommand);
   this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
   this.Load += new System.EventHandler(this.Page_Load);

  }
  #endregion
// 編輯

private void dgShow_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   dgShow.EditItemIndex = e.Item.ItemIndex;
   BindData();

  }
 //取消編輯
  private void dgShow_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   dgShow.EditItemIndex = -1;
   BindData();
  }
  //定義翻頁事件
  private void dgShow_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
  {
   dgShow.CurrentPageIndex = e.NewPageIndex;
   BindData();
  }
//刪除事件
  private void dgShow_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   if(dgShow.Items.Count==1)
   {
    if(dgShow.CurrentPageIndex!=0)
     dgShow.CurrentPageIndex = dgShow.CurrentPageIndex-1;
   }
   string strSql = "delete from tbStudentinfo where studentid="+e.Item.Cells[0].Text+"";
   ExecuteSql(strSql);
   BindData();

  }
  ////////////////////////////////////////////////////////////
  //說明：執行制定SQL語句/////////////////////////////////////
  ///////////////////////////////////////////////////////////
  private void ExecuteSql(string strSql)
  {
   try
   {
    string strconn = System.Configuration.ConfigurationSettings.AppSettings["DSN"];//從Web.config中讀取
    SqlConnection conn =new SqlConnection(strconn);
    SqlCommand com = new SqlCommand(strSql,conn);
    conn.Open();
    com.ExecuteNonQuery();
    conn.Close();
   }
   catch(Exception e)
   {
    Response.Write("<script language = 'javascript'>alert('"+e.Message+"');</script>") ;
       
   }
  }
  //更新數據
  private void dgShow_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   string strStudentID = e.Item.Cells[0].Text;//處于非編輯狀態
   string strName = ((TextBox)(e.Item.Cells[1].Controls[0])).Text;//處于編輯狀態
   string strPass =((TextBox)(e.Item.Cells[2].Controls[0])).Text;
   string strSex = ((CheckBox)(e.Item.Cells[3].FindControl("cbSex"))).Checked?"1":"0";
   string strBirthday =((TextBox)(e.Item.Cells[4].Controls[0])).Text;
   string strEmail =((TextBox)(e.Item.Cells[5].Controls[0])).Text;
   string strSql = "update tbStudentinfo set StudentName='"+strName+"',StudentPass='"+strPass+"'";
   strSql +=",Sex="+strSex+",Birthday='"+strBirthday+"',Email='"+strEmail+"' where studentid="+strStudentID+"";
   ExecuteSql(strSql);
   dgShow.EditItemIndex = -1;
   BindData();

  }
//全選事件
  public void CheckAll(object sender, System.EventArgs e)
  {
   CheckBox cbAll = (CheckBox)sender;
   if(cbAll.Text=="全選")
   {
    foreach(DataGridItem dgi in dgShow.Items)
    {
     CheckBox cb = (CheckBox)dgi.FindControl("cbSelect");
     cb.Checked = cbAll.Checked;
    }
   }
  }

//刪除按鈕事件
  private void btnDelete_Click(object sender, System.EventArgs e)
  {
   foreach(DataGridItem dgi in dgShow.Items)
   {
    CheckBox cb = (CheckBox)dgi.FindControl("cbSelect");
    if(cb.Checked)
    {
     //以下執行刪除操作
     int nID = int.Parse(dgi.Cells[0].Text);
     string strSql = "delete from tbStudentinfo where studentid="+nID;
     ExecuteSql(strSql);
    }
   }
   dgShow.CurrentPageIndex = 0;
   BindData();
  }

 }
}