Export table rows directly to a csv file using asp.net C#

Question

How do I export result of a sql query to a csv file without mapping to an object. Is there a direct way for this?

gor · Accepted Answer · 2011-02-25 11:53:47Z

1

Retrieve data from database using IDataReader, and in a loop write all it's fields to csv file.

Also you can use csvhelper to write csv.

answered Feb 25, 2011 at 11:47

gor

11.6k5 gold badges39 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Is this looping will cause any performance issue as I will have more than 3000 records each time

Pankaj · Accepted Answer · 2011-02-25 12:13:25Z

0

You can directly handle this situation in data base.I mean directly import data into csv else you handle in code.

answered Feb 25, 2011 at 12:13

Pankaj

4,52318 gold badges54 silver badges74 bronze badges