Save and retrieve zip file in c#

[kontakt07]

Hello,

I've searched everywhere for this and can't find an answer.

I want to save a .zip file to a MS SQL 2005 Database and retrieve it from there and stream it to the user's browser.

Would someone help me with a complete example in C# on how to do this.

Every example I've seen is about image binary data, and still can't find a complete working example.

Thanks in advance.

[r035198x]

The examples work for zip files too except for the streaming part.
As long as you store the data in a column of type BLOB (Binary Large Object) it should work

[Curtis Rutland]

In SQL 2k5 the BLOB column type is called "Image" but it is the same thing.

The general idea is this:

• Read the file's bytes into a byte[] using a FileStream
• Do an INSERT on a table using the byte[] as a parameter for the Image column
• When you need to, SELECT the data out into a byte[]
• You can either write that to a temp file, or you can use the Response.BinaryWrite method to directly write to the response stream, if you set the headers correctly.

Hope that helps.