How to export SQL table data to CSV (C# code)

This video shows how we can write C# code to export SQL table data to CSV file using DataReader object.
Credit :
Music : UA-cam Audio Library

[@markkane4220]

It would nice to have the source code it a file. I could have skipped the whole video.

[@brunomotta26]

hello, is it possible to make two queries with this method and export in different sheets?

[@codeandexecute-gsm]

Thanks for watching this video. This method is for CSV file. You can try to export your two tables' data to an excel in two different sheets. You can check my recent videos on exporting data to excel using ClosedXML or EPPlus.

[@brunomotta26]

@@codeandexecute-gsm ok, i will look at them, thank you very much

[@lmsweed]

Exactly what I needed, thank you!

[@codeandexecute-gsm]

Glad it helped! thanks for watching this video...

[@vitn887]

Hey, I would love to change form of date export -> instead of dd.mm.yy to yy.mm.dd. And Numbers separate by . instead of ,
Thanks for help. :)

[@alexander112330]

thx!

[@mireq3461]

Hi, for me it skips first row from the database (I suppose it is being replaced by header). How can I fix that?

[@aethenwulf4757]

i have the same problem lol.
(tell me how if you fix it please)

[@aethenwulf4757]

bro i fix mine, if you wan't the answer just comment here again.

[@SomeRandomPerson101]

@@aethenwulf4757 I am now facing the same problem.
How did you fix the error?

[@aethenwulf4757]

@@SomeRandomPerson101 i use while loop and add i++ inside. or delete the "if (DataReader.Read)" on header part