Dump DataTable to text

G

Guest

How can I dump my datatable to a comma delimited (or tab delimited) text file in VB.NET?

I was thinking I could simply call an (external) SQL 2000 DTS package, but since I have the data in the Datatable, it would be a waste to requery.

Div
 
M

Miha Markic

Hi Diva,

You might consider a simple loop through all rows and write directly to
file..

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

Diva said:
How can I dump my datatable to a comma delimited (or tab delimited) text file in VB.NET?

I was thinking I could simply call an (external) SQL 2000 DTS package, but
Click to expand...
since I have the data in the Datatable, it would be a waste to requery.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

load flat file into datatable 2
Open file suddenly stops existing?! 11
How to specify a schema when filling a DataTable from a .csv file 3
Datatable to Tab Delimited Text file 2
datacolumn datetime from UTC to Localtime 2
Clear a datatable before inserting new records 7
How do I programattically add a new row of data to a Typed DataSet? 8
Exporting data from a DataTable in format other than XML 4

Top