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, ...