close
DataGrid中製作Delete(刪除)按紐
HTML
在DataGrid的asp:ButtonColumn屬性增加下面這一段
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();
}
全站熱搜
留言列表
