Writting Dataset

[David]

Hello, and thanks in advance for any help you may offer.

My application returns data from SQL Server to a
DataSet. I need to write that DataSet to a .txt document
so it can be printed. I am using CF, and HP's printing
toolbox.

Any help is greatly appreciated

Thanks
David

[William Ryan eMVP]

Hi David:
Just to be sure, CF == CompactFramework?

Anyway this should work:

foreach(DataRow dro in DataSetName.Tables[TableIndex].Rows){
for(int i = 0; i < DataSetName.Tables[Whatever].Columns.Count){
//write out values here
}

}

You can do it a few ways...build a stringbuilder for instance and then just
write that to a text file, or write the text as you walk through everything.
If you are on the cf, then you have limited resources so you probably want
to write directly.

HTH,

Bill
"David" <ds*********@hotmail.com> wrote in message
news:92****************************@phx.gbl...

Hello, and thanks in advance for any help you may offer.

My application returns data from SQL Server to a
DataSet. I need to write that DataSet to a .txt document
so it can be printed. I am using CF, and HP's printing
toolbox.

Any help is greatly appreciated

Thanks
David