public int DeleteAll(int[] ids) { List<SqlParameter> list = new List<SqlParameter>(); string sql = "delete from NewsInfo where Id in ("; //拼接参数 for (int i = 0; i < ids.Length; i++) { sql += "@id" + i + ","; list.Add(new SqlParameter("@id"+i,ids[i])); } //截取掉最后一个逗号 sql = sql.Substring(0,sql.Length - 1); sql += ")"; return SQLServerHelper.ExecteNonQuery(sql,list.ToArray()); } 希望能帮助你
上面不都写了吗,你循环获取这些ID,然后拼一拼 然后 SQL 里where id in (ID1,ID2,ID3....)
把选中的几项删除后台要怎么写
{
List<SqlParameter> list = new List<SqlParameter>(); string sql = "delete from NewsInfo where Id in ("; //拼接参数
for (int i = 0; i < ids.Length; i++)
{
sql += "@id" + i + ",";
list.Add(new SqlParameter("@id"+i,ids[i]));
} //截取掉最后一个逗号
sql = sql.Substring(0,sql.Length - 1);
sql += ")"; return SQLServerHelper.ExecteNonQuery(sql,list.ToArray());
}
希望能帮助你
然后 SQL 里where id in (ID1,ID2,ID3....)