DataGrid删除操作

首先加入删除按钮。

之后：

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();

        }