Download file that stored in sql server

angshujit · February 20th, 2007, 07:03 AM

Hi,
I have tried to implement file download option. I can download file which is stored in any folder. Code is...

        string filepath = Request.Params["file"].ToString();
        string filename = Path.GetFileName(filepath);
        Response.Clear();
        Response.ContentType = "image/gif";
        Response.AddHeader("Content-Disposition", "attachment; filename=" + filename);
        Response.Flush();
        Response.WriteFile(filepath);

This code is working fine. Now I want to store the file in database table. User can download file from the database. How can I do this? The file may be a .txt, .doc, .xls, .jpg or .gif.

dparsons · February 20th, 2007, 08:50 AM

You will need to convert your file to a byte stream and place it in your SQL Server in a column of type image. You will also need to store the length and content type of the uploaded file so that you can push it back down to the client correctly.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429

angshujit · February 20th, 2007, 09:40 AM

Thank you for your reply. I have tried it. It is showing an error. Code is...
    string name = fLoad.FileName;
    System.IO.Stream str = fLoad.FileContent;
    int len = (int)str.Length;
    Byte[] byteData = new Byte[len];
    str.Write(byteData, 0, len); //Error is here

And the error is...
     Specified method is not supported.
How to fix it?
Angshujit

dparsons · February 20th, 2007, 09:51 AM

Read this.

http://www.developer.com/net/asp/article.php/3097661

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429

angshujit · February 20th, 2007, 10:15 AM

Woh...its working. Thank you. How can I download that file? I know how to download file from a folder. But from database?

Angshujit

dparsons · February 20th, 2007, 10:17 AM

On that same page read about the Method DeliverFile. It explains it point blank.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429

angshujit · February 21st, 2007, 06:40 AM

At last... it is working...
Now, user can upload any type of files. I have written the Response.ContentType for .txt, .doc, .xls, .jpg, .jpeg, .gif and .pdf. Now if any user upload any other file then in the time of download I want to zip that file before download. How can I zip a file?
Angshujit

dparsons · February 21st, 2007, 08:59 AM

You should really try researching this stuff before you post a question. Google is a great resource, use it. http://www.aspheute.com/english/20011115.asp

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429

angshujit · February 22nd, 2007, 06:37 AM

OK. it is working....
Sorry to post this type of question. Since I am new in .net so I have posted this question.

Angshujit