C#-DataGridView分页功能的实现(用存储过程实现).docVIP

C#-DataGridView分页功能的实现（用存储过程实现） 用SqlDataAdapter实现的分页功能很多浏览者都提意见说不好，一次性读出全部数据会影响程序的占用率，造成计算机的“短路”。呵呵，那好把，这次用数据库的存储过程去实现分页，这样是每次按一定数量去读取数据记录，这种方法应该是目前最稳定和最省资源的方法了（嘻嘻嘻，如果还有高手知道有比这更好的方法，请提出，小弟在此谢过）。???? 首先在数据库里建立以下存储过程： CREATE?PROCEDURE?dt_DXS_STAFF_ACTIVE?@STAFFSTATUS?INT,@STAFFNUM?INT,@STARTNO?INT,@@TOTALCOUNT?INT?OUTPUT,@@REALNUM?INT?OUTPUT?ASDECLARE?@PRERECCOUNT?VARCHAR(10)DECLARE?@CURRECCOUNT?VARCHAR(10)SELECT?@@TOTALCOUNT=COUNT(*)?FROM?DXS_STAFF_ACTIVEIF?@@TOTALCOUNT(@STARTNO+1)*@STAFFNUM???SET?@@REALNUM=@STAFFNUMELSE????SET?@@REALNUM=@@TOTALCOUNT-@STARTNO*@STAFFNUMSET?@CURRECCOUNT=CAST(?@STARTNO?*?@STAFFNUM?+?@@REALNUM?AS?VARCHAR(?10?)?)IF?@STARTNO?=?0?????EXEC(?SELECT?TOP??+?@CURRECCOUNT?+??STAFF_ID,STAFF_NAME,RDATE,TDATE,DEPT,MEMO?FROM?DXS_STAFF_ACTIVE?WHERE?STATUS=+@STAFFSTATUS+?ORDER?BY?STAFF_ID?ASC?)ELSE???BEGIN?????????SET?@PRERECCOUNT=?CAST(?@STARTNO?*?@STAFFNUM?AS?VARCHAR(?10?)?)?????????EXEC(?SELECT?TOP??+?@CURRECCOUNT?+??STAFF_ID,STAFF_NAME,RDATE,TDATE,DEPT,MEMO?FROM?DXS_STAFF_ACTIVE?WHERE?STAFF_ID?NOT?IN?????????????????????+?(SELECT?TOP??+?@PRERECCOUNT?+?STAFF_ID?FROM?DXS_STAFF_ACTIVE?WHERE?STATUS=+@STAFFSTATUS+?ORDER?BY?STAFF_ID?ASC)????????????????????+?ORDER?BY?STAFF_ID?ASC???????????????????)???ENDGO 具体的建立存储过程我就不说了，简单说明一下以上语句的作用把。???CREATE PROCEDURE dt_DXS_STAFF_ACTIVE 其实就是生成一个名为dt_DXS_STAFF_ACTIVE的存储过程，具体命名按实际需要。?? TOTALCOUNT：数据行总数。?? REALNUM：当前记录数。?? 以下是将数据导入页面的函数： private?void?LoadPage()????????{????????????dtStaff.Clear();????????????SqlConnection?conn?=?new?SqlConnection(Param_Class.Param_DB.strConn);????????????SqlDataAdapter?Sda?=?new?SqlDataAdapter();????????????SqlCommand?sqlComm?=?new?SqlCommand();????????????sqlComm.Connection?=?conn;????????????sqlComm.CommandText?=?dt_DXS_STAFF_ACTIVE;????????????sqlComm.CommandType?=?CommandType.StoredProcedure;????????????sqlComm.Parameters.AddWithValue(@STAFFSTATUS,pStatus);????????????sqlComm.Parameters.AddWithValue(@STAFFNUM,?pageSize);????????????sqlComm.Par