Saving data to text file

[Carl Howarth]

Hi,

Using ADO I could save a recordset out as text... Is there an equivalent for
the sqldatareader?

Cheers, Carl

 

[Greg Low \(MVP\)]

Hi Carl,

For a sqldatareader, you could either:

1. cycle through the rows and write them to a text file manually.
2. add the data to a dataset and then call its method to save it as xml (if
you just want to persist the set of rows in a text file you could re-read
them from).

HTH,