I have an application (VB.Net, SQL Server) in which users routinely need to display large amounts of data. We are currently getting the data from the database via stored procedures. The data is then loaded into ADO.Net data tables and data sets. The data is displayed using a DataGridView class which uses a DataView as a binding source. We are finding that when we load large amounts of data into the datagrid there is a considerable delay, which seems to be much larger than a similar amount of data being displayed in Qurey Analyzer. Does anyone have any suggestions for speeding up the data display, or are there better objects to use for displaying large amounts of data
TIA
Ron L
Best way to display large datasets
Minot
Thank you all for your responses.
Ron L
fredrikt
braveocean
Assuming this is a Windows Forms app, you may want to consider using a custom paging mechanism. The following should help:
How To Perform Paging with the DataGrid Windows Control by Using Visual Basic .NET
kaizen
hi,
if you have used cursors in your stored procedures try to remove, and try not to return to database once gone for a function call
post more details