Exporting

[brian]

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

[Michael Pearson]

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

[George Durzi]

Transform the DataSet to text using an Xsl stylesheet. Not at work right
now, so don't have my code lib, email me and I can send you some code
snippets for simple transforms.

"Michael Pearson" <mi************************@televox.com> wrote in message
news:u%****************@TK2MSFTNGP11.phx.gbl...

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