I have a windows application developed in framework 2.0.
I need to export 300000 from a mysql database need some formatting and write into CSV file.
For that i am doing the following steps
1. Read data from database to a data set
2. Reads the data by datarow [ foreach (DataRow drExport in dsToExportgeneral.Rows)}
3. Will do some formatting and write into another dataset
4.Then will write the formatted dataset as a csv file
Am getting error "System.OutOfMemoryException" after reading around 60000 records..
Is there any way to fix this issue