create csv and zip file from dataset

[blarfoc]

Hi, I have a question that should be easy to do. I need a user to be
aable to get the contents of a dataset to a csv file in a zip file.
Here is my example. The user will run a store procedure that is to
return 12 datatables. Each data table is the same schema and each is
for each of 12 months. I want the user to get the dataset filled with
the 12 datatables and then have each datatable converted to a csv file
and then the 12 csv files put into a zip file so that the user can save
the zip file to their computer. How do I do this all? I only want one
zip file wiht 12 csv files in it.

thank you

 

[Guest]

Moving to CSV, whether custom created or throw ADO.NET, is easy. For ZIP, you
will have to use a zip library. The guys who developed SharpDevelop have a
nice zip library:

http://www.icsharpcode.com/OpenSource/SharpZipLib/Default.aspx


---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************