leodo@blog

HTML

---

在DataGrid的asp:ButtonColumn屬性增加下面這一段
<asp:ButtonColumn HeaderText="功能" Text="&lt;div id=&quot;de&quot; onclick=&quot;JavaScript:return confirm('確定要刪除？')&quot;&gt;刪除&lt;/div&gt;" CommandName="Delete">

---

C#    CodeBehind

---

 private void dgHR_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   string key = dgHR.DataKeys[e.Item.ItemIndex].ToString();
   string sql = "Delete from ALLIANCE_HR where EMP_NO = '" + key + "'";
   SqlConnection conn = new SqlConnection(Config.CONN_STRING);
   conn.Open();
   SqlCommand cmd = new SqlCommand(sql,conn);
   cmd.ExecuteNonQuery();
   cmd.Dispose();
   conn.Close();
  }