Writing From A dataset to a comma delimited text file

[John Tyce]

Does any one know how to write the data from a dataset table to a text file? I have found a clumsy way to do it using WriteXml, XmlReader, XmlNodeReader, etc, but this seems awful clumsy. Is there a better way to do this?

--
JOHN TYCE

[Nicholas Paldino [.NET/C# MVP]]

John,

There is no way to do it out of the box. You will have to write the
file yourself (cycling through all columns for each row).

You ^might^ be able to do it using a text provider (I think that there
was one for OLEDB), but I am not sure that would work. Or perhaps, an ODBC
provider.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"John Tyce" <jt***@chevrontexaco.com> wrote in message
news:eq*************@TK2MSFTNGP12.phx.gbl...
Does any one know how to write the data from a dataset table to a text file?
I have found a clumsy way to do it using WriteXml, XmlReader, XmlNodeReader,
etc, but this seems awful clumsy. Is there a better way to do this?

--
JOHN TYCE

[Patrick Altman]

John,

Check this link out:
http://support.microsoft.com/default...b;EN-US;306023

--
Patrick Altman
[Remove "JUST_SAY_NO_TO_SPAM" to send me email.]
"John Tyce" <jt***@chevrontexaco.com> wrote in message
news:eq*************@TK2MSFTNGP12.phx.gbl...
Does any one know how to write the data from a dataset table to a text file?
I have found a clumsy way to do it using WriteXml, XmlReader, XmlNodeReader,
etc, but this seems awful clumsy. Is there a better way to do this?

--
JOHN TYCE

[John Tyce]

Thanks Patrick. That may be very helpful.

--
JOHN TYCE
"Patrick Altman" <paltman@gmailJUST_SAY_NO_TO_SPAM.com> wrote in message
news:el**************@TK2MSFTNGP09.phx.gbl...

John,

Check this link out:
http://support.microsoft.com/default...b;EN-US;306023

--
Patrick Altman
[Remove "JUST_SAY_NO_TO_SPAM" to send me email.]
"John Tyce" <jt***@chevrontexaco.com> wrote in message
news:eq*************@TK2MSFTNGP12.phx.gbl...
Does any one know how to write the data from a dataset table to a text file? I have found a clumsy way to do it using WriteXml, XmlReader, XmlNodeReader, etc, but this seems awful clumsy. Is there a better way to do this?

--
JOHN TYCE

[Ignacio Machin \( .NET/ C# MVP \)]

Hi John,

Here is the code I'm using , it comes from a PPC app and does exactly what you want :)

StreamWriter writer = new StreamWriter( Config.DataPath + "\\" + Config.OldOrdersFile, false);
writer.WriteLine("Tablename=OldOrders");
foreach(DataRow dr in _oldOrders.Tables[0].Rows )
{
StringBuilder builder = new StringBuilder( 200); // None row is bigger than this
foreach(object o in dr.ItemArray)
{

builder.Append( o.ToString() );
builder.Append( ',' );
}
builder.Remove( builder.Length-1, 1);
writer.WriteLine( builder.ToString() );
}
writer.Close();

Cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"John Tyce" <jt***@chevrontexaco.com> wrote in message news:eq*************@TK2MSFTNGP12.phx.gbl...
Does any one know how to write the data from a dataset table to a text file? I have found a clumsy way to do it using WriteXml, XmlReader, XmlNodeReader, etc, but this seems awful clumsy. Is there a better way to do this?

--
JOHN TYCE