General discussion

Locked

Export SQL Data to Flat File in ASP.NET

By bgibilaro ·
I need to create an simple web app that will allow our client to query a SQL database and then export the returned recordset to a flat file.

I am using ASP.NET to develop this app.

In ASP.NET, how can I take a returned recordset and save the info to a flat file on the user's computer?

Any help would be greatly appreciated.

Thanks!

Bob Gibilaro

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Export SQL Data to Flat File in ASP.NET

by amanabala In reply to Export SQL Data to Flat F ...

Bob,

I worked on a similar project and I found the following article at Microsoft site very helpful.

"HOW TO: Use ASP.NET to Query and Display Database Data in Excel by Using Visual Basic .NET"
http://support.microsoft.com/default.aspx?scid=kb;en-us;308247

The sample code will create a comma delimited file with extension ".xls" You can change the extension as you need.

Hope this helps.
Ravi
ananth_manabala@yahoo.com

Collapse -

Export SQL Data to Flat File in ASP.NET

by bgibilaro In reply to Export SQL Data to Flat F ...

Ravi,

This worked perfectly. (Easy too!) Thank you so much for your help.

Bob Giblaro

Collapse -

Export SQL Data to Flat File in ASP.NET

by bgibilaro In reply to Export SQL Data to Flat F ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums