Last post Apr 25, 2012 02:09 PM by bakra
Apr 25, 2012 04:46 AM|ericyzhou|LINK
In ObjectDataSource we can utilize database for paging and sorting but in SqlDataSource control this feature does not exist, am I right?
SqlDataSource seems to be able to return data in either a DataReader or DataSet, then try to run sorting and paging based on the DataSet returned. Even if there is a 1,000,000 records in the DataSet.
Then what is the advantage for SqlDataSource?
Apr 25, 2012 02:09 PM|bakra|LINK
If you are using a sql datasource instead of object datasource, you can try to implement custom paging on database side using stored procedure. See link below for possible guideline:
Please "Mark as Answer" if this helped you