这个删除错误应该如何解决?急救!!!! delete from myTable where id=1 or id=2 or..... 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 用一个循环,每次只delete一次(我是这样做的) 我写错了,我的删除语句是 delete from myTable where id=1 or id=2 or.....除了用循环,有没有更好的办法,用循环会增加服务器负担吧。 delete from myTable where id=1 or id=2delete from myTable where id in(1,2)都可以,看你的代码? 我的代码:string deleteStr = "Delete From table where ";string s = CheckSelectedItem();//生成查询条件语句deleteStr += s;string selectStr = "Select * from table where " + s;string connString = ......;SqlConnection myConnect = new SqlConnection(connString);SqlCommand mySelect = new SqlCommand(selectStr,myConnect);DataSet ds = new DataSet();SqlDataAdapter myAdapter = new SqlDataAdapter(selectStr,myConnect);SqlCommand delCommand = new SqlCommand(deleteStr,myConnect);myAdapter.DeleteCommand = delCommand;try{myAdapter.Fill(ds,"table"); for(int i=0;i<ds.Tables["table"].Rows.Count;i++){ ds.Tables["table"].Rows[i].Delete();}myAdapter.Update(ds,"table");//就在这里出错 SqlCommand delCommand = new SqlCommand(deleteStr,myConnect);delCommand.ExecuteNonQuery();就删除成功! gridview如何让一笔记录显示为两行 如何让id为b的div相对于屏幕居中 导出excel出现脚本“未指明错误”的问题 求组表结构设计问题 一个关于Request.Params["ArticlesID"]的例子,请高手指点。 请教一个Session的问题??? 前台和后台的定义 请问如何实现datagrid分页上实现排序?? 如何写SELECT语句 关于DataGrid1.DataKeys的问题 我精心编写的程序女友不敢看!散分! 说的不对不给分呦
delete from myTable where id=1 or id=2 or.....除了用循环,有没有更好的办法,用循环会增加服务器负担吧。
delete from myTable where id in(1,2)都可以,看你的代码?
string deleteStr = "Delete From table where ";
string s = CheckSelectedItem();//生成查询条件语句
deleteStr += s;
string selectStr = "Select * from table where " + s;
string connString = ......;
SqlConnection myConnect = new SqlConnection(connString);
SqlCommand mySelect = new SqlCommand(selectStr,myConnect);
DataSet ds = new DataSet();
SqlDataAdapter myAdapter = new SqlDataAdapter(selectStr,myConnect);
SqlCommand delCommand = new SqlCommand(deleteStr,myConnect);
myAdapter.DeleteCommand = delCommand;
try
{
myAdapter.Fill(ds,"table");
for(int i=0;i<ds.Tables["table"].Rows.Count;i++)
{
ds.Tables["table"].Rows[i].Delete();
}
myAdapter.Update(ds,"table");//就在这里出错
delCommand.ExecuteNonQuery();
就删除成功!