Question

C#下sql语句提示有语法错误

form中有datagridview空间，代码功能是删除选中行的内容
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=D:\\study\\毕业设计\\逆变器db\\逆变器db\\DBsql.mdf;Integrated Security=True;User Instance=True";
conn.Open();
int i = Convert.ToInt32(dataGridView1.CurrentRow.Cells["编号"].Value);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "delete * from nibianqi where 编号=" + i;
cmd.Connection = conn;
cmd.ExecuteNonQuery(); //在这显示 '*' 附近有语法错误。 SqlDataAdapter ads = new SqlDataAdapter("select * from nibianqi", conn);
DataSet ds = new DataSet();
ads.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
conn.Close();
conn.Dispose();
请问是怎么回事 新手上路，高人指点，不胜感激！

Answer 1

请问你的sql 是什么版本的啊？
把sql语句改成下面的试下
"delete from nibianqi where 编号="+i;

Answer 2

大哥。。。是Delte FROM nibianqi where 编号=。。。Delete不用星号的。。

Answer 3

把 delete 后面的 *号去掉。

Answer 4

"delete from nibianqi where 编号='" + i+"'";
这样就对了

Answer 5

cmd.ExecuteNonQuery(); 注释掉