string sql = "DELETE FROM Feed" + nian + " WHERE FB=" + ss + "";
int d =SqlHelper.ExecuteNonQuery(sql,connstr);
sqlhelper 类 ExecuteNonQuery 删除命令,提示错误
System.ArgumentException:“不支持关键字: “delete from feed2022 where FB”。”
FB
的值用单引号括起来,如:
string sql = "DELETE FROM Feed" + nian + " WHERE FB='" + ss + "'";
尽量用参数化查询,拼接字符串容易出错还有风险。