代码如下:string username =zz;
SqlConnection conn3 = new SqlConnection();
SqlCommand cmd3 = new SqlCommand();
conn3.ConnectionString = ConfigurationSettings.AppSettings["ConnectionString"];
cmd3.CommandText = "delete from Level where username=" + username ;
conn3.Open();
cmd3.Connection = conn3;
cmd3.ExecuteNonQuery();
conn3.Close();
说明:表Level 中主键是username,想根据this.Label1.Text的值去删除Level 表中对于的记录
提示出错:列名 'zz' 无效
这是什么原因呢?
SqlConnection conn3 = new SqlConnection();
SqlCommand cmd3 = new SqlCommand();
conn3.ConnectionString = ConfigurationSettings.AppSettings["ConnectionString"];
cmd3.CommandText = "delete from Level where username=" + username ;
conn3.Open();
cmd3.Connection = conn3;
cmd3.ExecuteNonQuery();
conn3.Close();
说明:表Level 中主键是username,想根据this.Label1.Text的值去删除Level 表中对于的记录
提示出错:列名 'zz' 无效
这是什么原因呢?
delete from Level where username='" + username + "'";
如果是string 的话那你应该要这样写:' "+username+"'看看你数据表中username 是什么类型,就知道怎么写了~