In the latest system upgrade, the browser is ready to be changed due to a large amount of data.
Here is the component socut. Data. dll. Directly wrap SQL statements in the outer layer to save the trouble of modifying the stored procedure. Send it to you.
Paging control: aspnetpager. dll
Paging component: socut. Data. dll
The best way to use this control is to directly pass the SQL query statement, as shown in the following example.
Socut. Data. executedataset ("select * From socut_data", aspnetpager1. pagesize * (aspnetpager1. CurrentPageIndex-1), aspnetpager1. pagesize );
I don't need to explain the following parameters. I believe anyone who has used aspnetpager knows this.
What if I want to get the total number of projects?
String SQL = "select count (1) from (" + spelled SQL statement + ") AAA ";
You can obtain the statistics in the preceding method.
If you use it, you can upgrade itCodeThe modification is minimized, and the paging stored procedure can only be confused by single table operations.
Give a download link http://data.socut.com/now completely free.