CODEWITHSUNDEEP
.netfilehelpers
Nick Dat Le
Nick Dat Le

Reputation: 369

Exporting DataTable using FileHelpers

I want to export the contents of a DataTable to a text delimited file using FileHelpers, is this possible? Here is what I have so far:

// dt is a DataTable with Rows in it
DelimitedClassBuilder cb = new DelimitedClassBuilder("MyClassName", "|", dt);
Type t = cb.CreateRecordClass();
FileHelperEngine engine = new FileHelperEngine(t);

I have to convert the contents of dt to an array of type "MyClassName" but I'm not sure how to do that? I know there is a FileDataLink class but none of them work with DataTable (or even a DataSet).

Upvotes: 3

Views: 2910

Answers (1)

Petros
Petros

Reputation: 8992

Maybe you could use this:

CommonEngine.DataTableToCsv(dt, "customers.csv", '|');

Upvotes: 6

Related Questions