by Codewiz51
5. May 2010 21:03
A lot of my after hours time is spent improving my XML DOM object skills.
However, when I looked over my projects at work, I realized CSV file formats are probably more important than XML. Why? Because engineers like to use Excel. It seems to be the most important adhoc analysis tool used in our industry. Long before our statistical analysis tools are unleashed, rough calculations are derived in Excel. And what is the file exchange medium of choice for importing data into Excel? Comma-Separated-Value files. More...
d91a5d2f-ed9d-4df8-849b-a62652cdc716|0|.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04
Tags: CSV, XML, Excel
Programming
by Codewiz51
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.