在gridview中不删除行？ [英] Row not delete in gridview?
本文介绍了在gridview中不删除行？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
protected void gid_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Label lblname = (Label)gid.Rows[e.RowIndex].FindControl("lblname");
con.Open();
string cmdd = "DELETE from grid where name='" + lblname + "'";
cmd = new SqlCommand(cmdd,con);
cmd.Parameters.AddWithValue("@name", lblname.Text);
cmd.ExecuteNonQuery();
con.Close();
fill_show();
}
代码无法正常工作
请给出解决方案
我尝试了什么：
code not work properly
please give solution
What I have tried:
protected void gid_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Label lblname = (Label)gid.Rows[e.RowIndex].FindControl("lblname");
con.Open();
string cmdd = "DELETE from grid where name='" + lblname + "'";
cmd = new SqlCommand(cmdd,con);
cmd.Parameters.AddWithValue("@name", lblname.Text);
cmd.ExecuteNonQuery();
con.Close();
fill_show();
}
推荐答案
更正
correction
string cmdd = "DELETE from grid where name=@name ";
cmd = new SqlCommand(cmdd, con);
cmd.Parameters.AddWithValue("@name", lblname.Text);
cmd.ExecuteNonQuery();
这篇关于在gridview中不删除行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
