protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string computer_number = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); //取出要删除记录的主键值
string scon = ConfigurationManager.ConnectionStrings["xmelmisConnectionString"].ConnectionString; //取出连接字符串
string str = "delete from computer_equipment where computer_number='" + computer_number + "'";
try
{
SqlConnection conn = new SqlConnection(scon); //创建连接对象
if (conn.State.ToString() == "Closed")
conn.Open();
SqlCommand comm = new SqlCommand(str, conn);
comm.ExecuteNonQuery(); //执行删除
comm.Dispose();
if (conn.State.ToString() == "Open")
conn.Close();
GridView1.EditIndex = -1;
gridviewBind();
}
catch (Exception ex)
{
Response.Write("数据库错误，错误原因：" + ex.Message);
Response.End();
}
}
调试后发现点删除没反应，到底哪里出错了
------解决方案--------------------------------------------------------
对楼主的代码略做了修改,也不知道能不能成,有个老问题还是要提SQL语句别去用拼接啊....标签这样的控件也罢了,要是文本框就惨咯......
- C# code
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int computer_number = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value); //取出要删除记录的主键值 (这里对你略作了修改,不清楚你的主键用得是啥类型,不过看number这个单词,以及常理来判断一般主键是int型) string scon = ConfigurationManager.ConnectionStrings["xmelmisConnectionString"].ConnectionString; //取出连接字符串 (其实这里多写scon变量是多余的,不过你既然这么做了么...就这样吧) string str = "delete from computer_equipment where computer_number=@computer_number"; SqlConnection conn = new SqlConnection(scon);//打造连接对象其实没必要放try里,try..catch其实是会消耗资源的,要尽量避免大段"不会发生异常的代码"往try里面扔 SqlCommand comm = new SqlCommand(str, conn); comm.Parameters.AddWithValue("@computer_number", computer_number);//AddWithValue方法,相当有用地 try { if (conn.State == ConnectionState.Closed) conn.Open(); comm.ExecuteNonQuery(); //执行删除 comm.Dispose(); } catch (Exception ex) { Response.Write("数据库错误，错误原因：" + ex.Message); Response.End(); } finally { if (conn.State == ConnectionState.Open)//这句一般扔finally 块里 conn.Close(); } GridView1.EditIndex = -1; //这样也是..没必要扔try块里 gridviewBind(); }