分页方案（待完成）

 

 

int pageSize=20; int pageIndex=1; string fields="*"; string table_name="T_article"; string SqlWhere=" WHERE editor='' "; string SqlOrderField="updateTime"; string querySql = "SELECT {0} FROM (SELECT TOP {1} {0} FROM (SELECT TOP {2} {0} FROM {3} {4} ORDER BY {5} DESC) a ORDER BY a.{5} ) b ORDER BY {5} DESC"; querySql = string.Format(querySql, fields, pageSize, pageSize*pageIndex, table_name, SqlWhere,SqlOrderField);