Question

关键字 'from' 附近有语法错误 怎么解决？？？ 求高手

StringBuilder str = new StringBuilder(); for (int i = 0; i < gv_gzrzck.Rows.Count; i++) { if (((CheckBox)gv_gzrzck.Rows[i].Cells[0].Controls[1]).Checked) //cells[0]是我gridview里多选框的位置 { str.Append(gv_gzrzck.DataKeys[i].Value + ","); //绑定数据的时候，把表主键绑定到gridview key里 } } string[] strArray = str.ToString().Split(','); //把ID字符串读取到数组 for (int i = 0; i < strArray.Length - 1; i++) //由于数组最后索引值为‘，’，所以 循环次数 -1 { string sqlstr1 = "Delete Sys_REC_Detail From Sys_REC_Detail,Sys_REC Where Sys_REC.SYS_REC_ID = Sys_REC_Detail.SYS_REC_ID and Sys_REC.SYS_REC_ID =" + strArray[i].ToString(); string sqlstr2 = "Delete from Sys_REC Where SYS_REC_ID =" + strArray[i].ToString(); string sqlstr = sqlstr1 + sqlstr2; AJXSqlDbA.Utility.ExecuteSql(sqlstr, "Data Source=AJXSERVER\\WIN2008;Initial Catalog=NWSystem01;User ID=sa;Password=123"); gv_gzrzck.DataBind(); } GDataBind();

Answer 1

sqlstr1 改为 string sqlstr1 = "Delete From Sys_REC_Detail,Sys_REC Where Sys_REC.SYS_REC_ID = Sys_REC_Detail.SYS_REC_ID and Sys_REC.SYS_REC_ID =" + strArray[i].ToString(); 试试！！

Answer 2

string
sqlstr1
=
"Delete
Sys_REC_Detail
From
Sys_REC_Detail,Sys_REC
这里from
后面怎么能加两个表呢????你是想把Sys_REC_Detail这个表里的内容全部删除?要是这样的话
delete
from
Sys_REC_Detail
where......