string IDlist="1,2,3";
批量删除数据
StringBuilder strsql=new StringBuilder();
strSql.Append("delect from table ");
strSql.Append(" where ID in ("+"'"+IDlist+"'"+")");
这样处理,只能删除一条数据而已
处理方法
string [] a=IDlist.Split(',');
for(int i=0;i<a.Length;i++)
{
string str=a[i];
strSql.Append("delect from table ");
strSql.Append(" where ID in ("+"'"+str+"'"+")");
}
这样就可以遍历去删除多条数据
SQL模糊查询
select ID,HigherNumber,LevelOf,LevelName,UserID,Password,LoginIP,LastLoginTime,UserName,Status FROM Users where ID like '%ddd%'or HigherNumber like '%ddd%'or LevelOf like '%ddd%' or LevelName like '%ddd%' or UserID like '%ddd%' or LoginIP like '%ddd%' or LastLoginTime like '%ddd%' or UserName like '%ddd%' or Status like '%ddd%'