当前位置: 代码迷 >> ASP.NET >> 【SQL分页有关问题】点击上一页的时候查询不对
  详细解决方案

【SQL分页有关问题】点击上一页的时候查询不对

热度:3743   发布时间:2013-02-25 00:00:00.0
【SQL分页问题】点击下一页的时候查询不对
C# code
 string strsql = "select top "                           + NUMCount + " * from tb_Student where  ID not in ( select top "                           + number + " ID from tb_Student where fengcai=" + num + "  order by ID desc )and fengcai=" + num + " and email='" + shengfen + "' order by ID desc";


------解决方案--------------------------------------------------------
外层多了 and email='" + shengfen + "'
  相关解决方案