Question

运行该Sql语句出现“在关键字 'order' 附近有语法错误。”

public DataTable SupesoftPage(string tableName, string fields, string orderFields, string sqlWhere, int pageSize, int pageIndex, out int pageCount, out int recordCount)
{
string commandText = "";
string str2 = "";
int num = pageSize;
DataTable table = null;
try
{
if (sqlWhere == "")
{
sqlWhere = " 1=1";
}
orderFields = orderFields.ToLower();
if (orderFields == "")
{
orderFields = "F_ID";
}
if (orderFields.IndexOf("desc") != -1)
{
str2 = orderFields.Replace("desc", "asc");
}
else
{
str2 = orderFields.Replace("asc", "") + " desc";
}
commandText = "Select Count(*) From " + tableName + " Where " + sqlWhere;
recordCount = DbHelperSQL.Exists1(commandText);
if ((recordCount % pageSize) == 0)
{
pageCount = recordCount / pageSize;
}
else
{
pageCount = (recordCount / pageSize) + 1;
if (pageIndex == pageCount)
{
num = recordCount % pageSize;
}
}
if (pageIndex > pageCount)
{
pageIndex = pageCount;
}
if (pageIndex < 1)
{
pageIndex = 1;
}
table = dataTable(string.Concat(new object[] {
"Select * From (Select top ", num, " * from (select * From (select Top ", pageIndex * pageSize, " ", fields, ",", orderFields.Replace("desc", "").Replace("asc", ""), " From ", tableName, " Where ", sqlWhere, " order by ", orderFields, ") order by ", str2,
")) order by ", orderFields
}));
}
catch (Exception exception)
{
throw exception;
}
return table;
}

Answer 1

order by后面那个字段的字段名用中括号括起来。

Answer 2

建议将最终的sql文打出来分析，这样看代码何其痛苦。

Answer 3

ACCESS库和sqlserver库在有些函数和关键字定义是不一样的，查一下sql函数说明和关键字说明吧

Answer 4

你可以把sql语句单独存起来，看下sql语句编写是否正确

追问

运行过了出现“'order' 附近有语法错误”，这个错误针对sqlserver数据库，换access数据库就可以运行