首先加入删除按钮。
之后:
private
void
userData_DeleteCommand(
object
source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
... {
string tempName=userData.Items[e.Item.ItemIndex].Cells[2].Text;
//Label1.Text=tempName;
//执行删除操作
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server=(local);uid=;pwd=;database=zxks;";
conn.Open();
//Response.Write("<script>alert('成功!');</script>");
string insSql="DELETE FROM Users WHERE UserName LIKE'"+tempName+"'";
SqlCommand cmd = new SqlCommand(insSql, conn);
cmd.ExecuteNonQuery();
Response.Write("<script>alert('删除成功!');</script>");
UserDataBind();
// else
// Response.Write("<script>alert('删除失败!');</script>");
conn.Close();
}
... {
string tempName=userData.Items[e.Item.ItemIndex].Cells[2].Text;
//Label1.Text=tempName;
//执行删除操作
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server=(local);uid=;pwd=;database=zxks;";
conn.Open();
//Response.Write("<script>alert('成功!');</script>");
string insSql="DELETE FROM Users WHERE UserName LIKE'"+tempName+"'";
SqlCommand cmd = new SqlCommand(insSql, conn);
cmd.ExecuteNonQuery();
Response.Write("<script>alert('删除成功!');</script>");
UserDataBind();
// else
// Response.Write("<script>alert('删除失败!');</script>");
conn.Close();
}