Loop through the dataset and write it out to file
Dim oRow as DataRow
Dim oDataSet as dataset
Dim oColum as DataColum
'Populate dataset
For each oRow in oDataset.tables(0)
For Each oColumn in oRow
'Write out details to file
Next
next
Michael
"brian" <bs******@lbrspec.com> wrote in message
news:09****************************@phx.gbl...
I am using vb.net and sql2000. What is the best way
using vb.net to export data to text file. I can retrieve
it through a dataset or reader. There are a lot of
columns. I perfer not to use the dts designer in
sql2000.
Does anyone have any white papers or other resources for
me to take a look at?
Thanks
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.556 / Virus Database: 348 - Release Date: 12/26/2003