index > Windows Forms Data Controls and Databinding > Best way to display large datasets?

Best way to display large datasets?

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

Ron L Monday, January 08, 2007 1:19 PM

2 things

1) use Virtual Mode on your DataGridView and fill the value's when needed with the CellValueNeeded event.
2) when you have large collections of data it is adviced to create your custom business objects to diminish the amount of overload.

Review also this Thread about large datasets

DamPee Monday, January 08, 2007 3:00 PM

I also experience some large dataset load delay, and at last we use pagingin datagrid, stored producedure can one time get (for example 100 rows from your database), it can improve the loading time when display, but I am not sure if meet your case:)

Bob zhu - SJTU Tuesday, January 09, 2007 3:09 AM

Damiaanhas gived some detail advices,i will give antother skillto improve the DGV's performace

do not use AutoSizeColumnsMode.AllCells,for the reason that the DGV will show only after it has loaded all data. if u use AutoGenerateColumns will much better

Gavin Jin - MSFT Tuesday, January 09, 2007 5:52 AM

Thank you all for your responses. I will look into how they will fit into out project.

Ron L

Ron L Tuesday, January 09, 2007 12:05 PM

You can use google to search for other answers

Custom Search

More Threads

• Crystal Report Change Table.Location Error!!!

• Data Validation on datagridview done how?

• Listbox grabbing cursor??

• inserting new child rows

• connecting grid through datasource from property.

• i faced the problem in vb.net about the add function when i second time log in the system view the database, then the previous data had lost. how i solve it?

• DataGridView VerticalScrollbar Member

• Bind with Complex Objects

• SortableBindingList + DataGridView: What's wrong?

• Bug??? Datagrid custom Column Styles