Click here to Skip to main content
15,895,084 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello,

I have big problems of performance with DataGridView. I have a table from 5000 to 15000 lines, if I reduce the data there is no performance problem.

My DataGridView.DataSource is BindingSource and BindingSource is connected to a BindingList.

My problem appears when there is a modification of a cell, when click on entrance or click on another cell, it takes from 2 till 4 seconds according to the machine.

After numerous tests I spotted that the main part of time was between CellParsing and CellValidated.
However the method CellParsing is not in question because when I overload it (no processing) it takes always so much time before arriving at CellValidated.

I also use the event OnCellValidating: I noticed that when I fill DataGridView[][].Value the processing is very long at this moment (breakpoints) whereas if I fill my BindingList I go out immediately of my method and the slowness is after the method (I do not find where).

It is a problem between data and grid or refresh ?

What solutions?

Thanks in advance.

What I have tried:

I tried the DoubleBuffered, Row and Column no enable autosizing, ...
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900