.net 高手救救我~~~~~

来源:百度知道 编辑:UC知道 时间:2024/05/20 14:17:27
各位大虾帮帮我啊...我在gridview里加了个checkbox复选框....我下了以下代码... 为什么删不了所选的内容??? 如果可以请从新写一段给我..小弟在此感激不尽!!!!!!
protected void Button1_Click(object sender, EventArgs e)
{

for (int i = 0; i < this.GridView1.Rows.Count; i++)
{

CheckBox cb = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
if (cb.Checked == true)
{
string selectedid = Convert.ToString(GridView1.Rows[i].Cells[0].Text);
string strSql = "DELETE FROM [dbo].[freedom] WHERE id =" + selectedid +"'" ;
string strconn = "server=192.168.2.83;database=GoodBoss;uid=sa;pwd=lsjdwgdyg";
SqlConnection myconn = new SqlConnection(strconn);
SqlCommand mycomm = new SqlCommand(strSql, myconn);
myconn.Open();

mycomm.ExecuteNonQuery();

selectedid ? 确实取到值了么

===================================================
string strSql = "DELETE FROM [dbo].[freedom] WHERE id =" + selectedid +"'"
少了一个逗号?
string strSql = "DELETE FROM [dbo].[freedom] WHERE id ='" + selectedid +"'"

WHERE id =" + selectedid +"'" ;
id后面貌似少个'