PageSQL = "Select Top " + PageSize + " " + DataFileds + " FROM " + DataTable + " Where " + DataFiled + " Not In (Selcet Top " + PageSize * (CurrentPage - 1) + " " + DataFiled + "From" + DataTable + " Order By " + DataOrders + " ) Order By " + DataOrders;
//在top后面加空格
top后面要加个空格
拼接sql习惯了,就自己会意识到这个问题,楼主完全可以自己调试的时候,把sql语句放到数据库中执行以下就明白了。试问: select top5 * from table1 这句话怎么可能正确呢?