Question

C#&ASP.NET中GridView删除一行数据的程序

求后台程序，我用的是SQL数据库

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{

}
是在这里面添加程序吗？怎么写？或者我还需要加什么控件吗
cc.mycon.Open()中cc是代表什么意思

Answer 1

直接在GridView1加Delete列也可以<asp:SqlDataSource ID="SqlDataSource1" runat="server"
DeleteCommand="DELETE FROM [stuent] WHERE [StuID]=@StuID"
SelectCommand="SELECT [StuID], [StuName], [Stupassword] FROM [stuent] "
ConnectionString="<%$ ConnectionStrings:xueshengConnectionString %>" >

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" AutoGenerateDeleteButton="True"
DataKeyNames="StuID" DataSourceID="SqlDataSource1">

如果protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
主要代码是
string strconn = Convert.ToString(ConfigurationManager.ConnectionStrings["sqlconn"]);//sqlconn自己命名
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
string strsql = "delete from customer where CustomID=@customid";//列名改成自己的
SqlCommand cmd = new SqlCommand(strsql, conn);
SqlParameter param = new SqlParameter("@customid", GridView1.DataKeys[e.RowIndex].Value);
cmd.Parameters.Add(param);
}
aspx那边要加OnRowDeleting="GridView1_RowDeleting

Answer 2

捕获行事件，获取数据对应的唯一键

追问

我要关键的程序啊，怎么写

Answer 3

直接操作数据库，cc.mycon.Open()中cc 应该是开启数据库连接sqlcontion