等待...15分

Question

private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
    //怎樣刪除某一項目
}

Answer 1

private void dg1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
SqlConnection cn=new SqlConnection(strConn);
cn.Open();
string key=this.dg1.DataKeys[e.Item.ItemIndex].ToString();
SqlCommand cmd=new SqlCommand("delete from users where user_id='"+key+"'",cn);
try
{
cmd.ExecuteNonQuery();
Response.Write("<script>alert('删除成功')</script>");
BindGrid1();
}
catch(Exception ex)
{
Response.Write(ex.ToString());
Response.End();
}
}