Question

c# winform 有两个条件的查询该如何写？

SqlConnection con = new SqlConnection(str2);
con.Open();
SqlCommand cmd = new SqlCommand("delete * from YiZhuList_Temp where MedName='" + medname+ "' and RecDate ='"+meddate+"'", con);
cmd.ExecuteNonQuery();
SqlCommand 这行 这样写报错：'*' 附近有语法错误。该如何写？

Answer 1

SqlCommand cmd = new SqlCommand("delete * from YiZhuList_Temp where MedName='" + medname+ "' and RecDate ='"+meddate+"'", con);

是这样的吧
SqlCommand cmd = new SqlCommand("delete from YiZhuList_Temp where MedName='" + medname+ "' and RecDate ='"+meddate+"'", con);

语法是
DELETE FROM 表名称 WHERE 列名称 = 值

Answer 2

delete from 表名 where 条件 你的delete 语法错了