System.Data.SqlClient.SqlException:''附近有语法错误.stringolb=Request.QueryString["lb"];stringoid=Request.QueryString["id"];StringxwstrSQL="select*from'"+olb+"'whereid='"+oid+"'";DataTabledt=DbManager.ExecuteQuery(xwstrSQL);

Question

System.Data.SqlClient.SqlException:'' 附近有语法错误.
string olb = Request.QueryString["lb"];
string oid = Request.QueryString["id"];
String xwstrSQL = "select * from '"+olb+"'where id = '"+oid+"'";
DataTable dt = DbManager.ExecuteQuery(xwstrSQL);

Answer 1

olb前后不要加单引号,即：
String xwstrSQL = "select * from "+olb+" where id = '"+oid+"'";