Hello All, I've got a Windows Form based application with a movable panel and a DataGridView component installed.
I used the datagridview to view, modify and save .csv and exel files. Using files with less than a 1000 records seems work okay and the component is quite responsive. However, if I load files with excess of 5000 records it then becomes slow and non responsive. With tables with rows 40000, it becomes totally unusable. The data file itself is loaded into a DataTable component and I use this as the DataSource for the control. I should also say that I have two events attached to the dataGridView. One that updates another component on selection change and another that opens another dialog when you double click on a row. I also have other functions that update the dataGridView which finds and updates duplicate data rows using the Select filter statement. The performance of this appears to be adequate. >From searching around on google the problem appears to be that every time you update a row e.g. add, remove or modify a row it updates the entire table. For example: If you have a small table with say 500 rows with 15 columns there are indvidually 7,500 events that are updated and in a modern Windows based system is not really a problem. However, if you have a table with 40,000 records and 15 columns then each time it raises 60,000 events each time you modify a row or cell. So I guess it's a case of preventing the events from being raised, but I also don't want to stop the double click event on a row from taking place. I've read other postings whereby improve the performance by using a bindingsource however experimenting with this hasn't really made much of an improvement. Can anyone help me in improving the performance of a dataGridView please? Thanks in advance, Richard -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
