I hava used ListView control to display data. It is working fine for small data, but as the data size increases, say it goes beyond 1000+ records in the database. It will take too much time to fetch records from database and then display on the ListView control.
Is there a better control for larger data? Or is there any alternative way ... e.g. the way google fetches numerous links when we search but displays only 10 at a time.
Loading
Javeed M ShaikhPosted Oct 26, 2011, 11:40 PM
You can use ListView with Paging as well as DataList with Paging. Repeater control is much faster than both the above but you need to add custom paging as it does not provided inbuilt as ListView and DataList. I would suggest in any control you use you should try to do the paging logic in the stored procedure rather than in the control by relying its own paging mechanism.
Following article from C# Corner is a good start:
http://www.c-sharpcorner.com/UploadFile/ynuthan/109092009101155AM/1.aspx
http://www.c-sharpcorner.com/UploadFile/mosessaur/custompaging08202006185153PM/custompaging.aspx
http://www.c-sharpcorner.com/UploadFile/john_charles/CustompagingASPNETSQLServerusingObjectDataSource04132009094149AM/CustompagingASPNETSQLServerusingObjectDataSource.aspx