What is the best approach to Convert DataTable into .CSV

Praveen Kumar

I have written the following two approach to Convert DataTable into .csv File

First Approach

Step 1:

By iteratiing over DataTable put all Coulmns then after each rows column's data with comma (,) separated into a StringBuilder object

Step 2:

Now create a new File1.csv file with StringBuilder object which contains csv file data.

Second Approach

Step 1:

Now create a new File1.csv file with empty string data.

Step 2:

Now use the file path of File1.csv to create a StreamWriter object (ie. sw) and use sw.Write() method into loop to of DataTable Rows.

Using StringBuilder or StreamWriter, which one is best.

If any other may be a best approach, kindly share.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar7y ago
Accepted answer
As per reviews in internet most of developers following first approach.
use below links, review the code which helps you to improve your code quality
https://stackoverflow.com/questions/4959722/c-sharp-datatable-to-csv/11873756
https://stackoverflow.com/questions/888181/convert-datatable-to-csv-stream
https://stackoverflow.com/questions/28503437/most-efficient-way-of-converting-a-datatable-to-csv
+3
Sonu Gupta7y ago
Hi, Go to below url- https://stackoverflow.com/questions/28503437/most-efficient-way-of-converting-a-datatable-to-csv
0