21. December 2009 12:49
I am not impressed with the speed of the DataGridView control in the following scenerio:
- Dataset is persisted as XML file.
- Dataset contains two tables, one relationship and two primary keys.
- Performance when accessing DataRows in code is very fast.
- Performance when populating the DataGridView control with 300+ rows and 40 columns of data from a table in the Dataset is abysmal.
We are using XML format to persist data for a variety of customer requirements. We probably should have used SQL Server mobile or compact edition, but we didn't.
Beware of using the DataGridView until you examine application performance with realistic data.