Export to flat file

[Kevin Humphreys]

Hi There,
I am developing an windows application using VB.NET and I need to export and
open the contents of my datagrid to a flat file. Preferably txt or wordpad.

Whats the best direction/chunk of code to do this?

Thanks,
Kevin.

[Spam Catcher]

"Kevin Humphreys" <kh********@hotmail.comwrote in
news:#v**************@TK2MSFTNGP04.phx.gbl:

I am developing an windows application using VB.NET and I need to
export and open the contents of my datagrid to a flat file. Preferably
txt or wordpad.

Whats the best direction/chunk of code to do this?

There is an open source library called "FileHelper" which can export to
CSV, Tab Delimited, etc.

SQL Server also supports file exporting... through DTS/SSIS.

--
sp**********@rogers.com (Do not e-mail)

[Cor Ligthert[MVP]]

Kevin,

Because you are talking about a DataGrid and not about a DataGridView, then
there is for sure a DataTable or DataSet as datasource.

The most simple is to save that as a XML file as

mydataset.WriteXML(path)

However you can as well loop through the tables and write a CSV or whatever.

Cor

[Mr. Arnold]

"Kevin Humphreys" <kh********@hotmail.comwrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...

Hi There,
I am developing an windows application using VB.NET and I need to export
and open the contents of my datagrid to a flat file. Preferably txt or
wordpad.

Whats the best direction/chunk of code to do this?

I don't know if this will put you in the ballpark. It just happens to be C#
and was in a Web solution. But it might give you a clue to get it to a file.
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
DataGrid1.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();

[Wolf Saenger]

There is an open source library called "FileHelper" which can export

to CSV, Tab Delimited, etc.

Can you provide a link please

tia
Wolf

[Spam Catcher]

Wolf Saenger <wo**********@web.dewrote in news:59706510ee38ca1db8b0cae190
@news.motzarella.org:

>There is an open source library called "FileHelper" which can export
to CSV, Tab Delimited, etc.

Can you provide a link please

http://filehelpers.sourceforge.net/
--
sp**********@rogers.com (Do not e-mail)

[Wolf Saenger]

>

http://filehelpers.sourceforge.net/

thank you