代码:"select top " + pageSize + " orderNumber,spm,guige,pihao,shuliang from [orderStatusInfo] where z_sid not in (select top "+(currentPage-1)*pageSize+" z_sid from [orderStatusInfo] order by z_sid) order by z_sid"; 我的目的是做分页处理,请指教!
(1)你的 (currentPage-1)*pageSize 这个地方出错了。 对参数的引用不能通过运算符之后再引用,系统会认为两个+之间是一个参数名字 "select top " + pageSize + " orderNumber,spm,guige,pihao,shuliang from [orderStatusInfo] where z_sid not in (select top (" +currentPage+ "-1)*" +pageSize+" z_sid from [orderStatusInfo] order by z_sid) order by z_sid";