how to fill datagridview with thousand of records quickly ?

Question

Hello, I want to show thousand of records in datagridview within a second, i tried some code but it takes some minutes to show data in datagriview. so help me how can i do this... sample code below - public void BindData() { OleDbCommand cmd = new OleDbCommand( "Select LC,Name from Ledger order by LC DESC" , con); OleDbDataAdapter da = new OleDbDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); dataGridView1.DataSource = dt; }

Amit Gupta · Answer

On addition tk what members said, you can use OleDbDataReader class instead of Fill function. OleDbDataReader reads the data in forwarded direction whereas Fill function fetches all data first and then depicted in gridview, which will be faster processing. secondly, you can use pagination functionality as thousands of records aren't read by anyone at a time, show them as 20 records (as per requirement). Considering the points definitely have a overall decent pwrformance

Mageshwaran R · Answer

Hi, Please refer the below link, it might helps you https://stackoverflow.com/questions/10226992/slow-performance-in-populating-datagridview-with-large-data

Rajanikant Hawaldar · Answer

https://stackoverflow.com/questions/10226992/slow-performance-in-populating-datagridview-with-large-data https://stackoverflow.com/questions/3580237/best-way-to-fill-datagridview-with-large-amount-of-data

Rajanikant Hawaldar · Answer

one this create view and call it in stored procedure then use

Rajanikant Hawaldar · Answer

Hi Ajit, let me know issue is fixed or not. There are basically 3 ways to display data in a DataGridView Create the rows manually in a loop, as you are currently doing: as you have noticed, it's very inefficient if you have a lot of data Use the DataGridView's virtual mode, as suggested by Jonathan in his comment: the DGV only creates as many rows as can be displayed, and dynamically changes their contents when the user scrolls. You need to handle the CellValueNeeded event to provide the required data to the DGV Use databinding: that's by far the easiest way. You just fill a DataTable with the data from the database using a DbDataAdapter, and you assign this DataTable to the DGV's DataSource property. The DGV can automatically create the columns (AutoGenerateColumns = true), or you can create them manually (you must set the DataPropertyName of the column to the name of the field you want to display). In databound mode, the DGV works like in virtual mode except that it takes care of fetching the data from the datasource, so you don't have anything to do. It's very efficient even for a large number of rows Thanks

Željko Perić · Answer

Hello Ajit N., By my experience there is no such solution that would fill and show one thousand or more rows of DataGridView faster than one second. I had a similar problem when developing apps for carpet service where I needed exactly the same thing to do, to show all selected client data in a DataGridView as fast as it can be done. The first problem was small RAM and low speed of central processor of the computer on which application was intended to run. That was the main hardware problem, that was preventing fast execution of the application . The second problem was DataGridView properties, especially Behaivor and Layout section. In the Layout section there are two options that directly influence on the execution speed of "Fill" and "Show" methods of the DataGridView . See image : If those properties are set for example to All Cells , whenever a DataGridView cell is filled with a new value that has length larger than cell with, the program shall adjust width of all cells inside same column to new one. So if this must be done for five hundred times, that would explain the low speed of the program. Many other properties of DataGridView are set so that similar events while the program is running do not influence the speed of program execution. There is need to find the proper compromise when DataGridView properties and speed are in question. I hope that this would lead You to the solution of Your problem. All the best, Željko Peric