Go Back   Velocity Reviews > Newsgroups > ASP Net
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

ASP Net - create csv and zip file from dataset

 
Thread Tools Search this Thread
Old 02-28-2005, 03:37 PM   #1
Default create csv and zip file from dataset


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



blarfoc@yahoo.com
  Reply With Quote
Old 02-28-2005, 04:05 PM   #2
=?Utf-8?B?Q293Ym95IChHcmVnb3J5IEEuIEJlYW1lcikgLSBNVlA=?=
 
Posts: n/a
Default RE: create csv and zip file from dataset
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/OpenSourc...b/Default.aspx


---

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

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


"" wrote:

> 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
>
>



=?Utf-8?B?Q293Ym95IChHcmVnb3J5IEEuIEJlYW1lcikgLSBNVlA=?=
  Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46