Ado. Net implements a simple non-connection paging method (one of dataadapter. Fill overload ).

PublicIntFill (
Dataset Dataset,
Int Startrecord,
Int Maxrecords,
String Srctable
);
 

 

 

Parameters

Dataset

Dataset to be filled with records and architectures (if necessary.

Startrecord

The number of records starting from scratch.

Maxrecords

The maximum number of records to be retrieved.

Srctable

The name of the source table used for table ing.

Return Value

Number of rows that have been successfully added or refreshed in dataset. This does not include rows affected by statements that do not return rows.

Dataadapter obtains the result set of its selectcommand fromStartrecordWhen the actual data is smaller than maxrecords, no error is thrown.

Note: This type of paging refers to the paging After retrieving all the data. It will not improve the efficiency. To improve the efficiency, it should also be solved from the data perspective.