Exporting
 

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

Re: Exporting
 

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" <bshannon@lbrspec.com> wrote in message
news:090501c3cf20$0cf4aa90$a001280a@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

Re: Exporting
 

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" <michaelp_extrajunktoremove@televox.com> wrote in message
news:u%23opJwyzDHA.3496@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" <bshannon@lbrspec.com> wrote in message
> news:090501c3cf20$0cf4aa90$a001280a@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
>
>