Question

c#删除数据库中的一条记录的问题

using (SqlConnection connection = new SqlConnection("server=ASUS-454F297228;uid=sa;pwd=;database=agenda"))
{
connection.Open();
SqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "delete * from messageinfo where mid=@id";
cmd.Parameters.AddWithValue("@id", num);
cmd.ExecuteNonQuery();}
运行时报*附近有语法错误，是哪里错了

Answer 1

是你的sql语句错了......

delete 语句不是那么写的...

给你举个例子:
下面的示例从 ProductCostHistory 表中删除 StandardCost 列的值大于 1000.00 的所有行。
DELETE FROM Production.ProductCostHistory
WHERE StandardCost > 1000.00;

多看联机帮助..

干掉* 是不可以的 会提示你的对象名无效

Answer 2

你把cmd.CommandText = "delete * from messageinfo where mid=@id";
改为cmd.CommandText = "delete * from messageinfo where mid='"+@id+"'";试试看

Answer 3

delete from messageinfo where mid=@id
把星干掉试下

Answer 4

delete from _table where ......
delete 不用*