Download file from filestream

Question

I have a field in database of type image which stores the file in binary format.

Now I want to give a facility to user from where the user can downlaod that file. I have the file data in byte array object. How can I display the open save dialoge box to user?

score 0 · Answer 1 · edited Oct 30 '12 at 08:24

This is an example to show blob images from the database, you can modify it to offer the file for download instead of showing the image (id is the image file id in the database):

void  CreateImage(string id)
{
    // Connection string is taken from web.config file.
    SqlConnection _con = new SqlConnection(
      System.Configuration.ConfigurationSettings.AppSettings["DB"]);

    try
    {
        _con.Open();
        SqlCommand _cmd = _con.CreateCommand();
        _cmd.CommandText = "select logo from" + 
                           " pub_info where pub_id='" + 
                           id + "'";
        byte[] _buf = (byte[])_cmd.ExecuteScalar();

        // This is optional
        Response.ContentType = "image/gif";

        //stream it back in the HTTP response
        Response.BinaryWrite(_buf);


    }
    catch
    {}
    finally
    {
        _con.Close();

    }
}

Thanks for your response, actully I am working on silverlight application — Rohit Vyas, Oct 30 '12 at 09:29

score 0 · Answer 2 · answered Oct 30 '12 at 08:18

0

Try to see this: Create ashx file handler serving the image with header:

Content-Type: application/force-download

answered Oct 30 '12 at 08:18

Fanda

3,760
5
37
56

Omar · Answer 3 · 2012-10-30T15:15:31.220

0

What about:

//using System.Net;   
WebClient wc = new WebClient();

OpenFileDialog ofd = new OpenFileDialog();
if(ofd.ShowDialog() == DialogResult.OK)
   wc.DownloadFile("http://website.net/image.jpg", ofd.FileName);

EDIT:

//using System.IO;
MemoryStream ms = new MemoryStream(array);
Bitmap bmp = new Bitmap(ms);
bmp.Save("C:\\image.bmp");

edited Oct 30 '12 at 15:15

answered Oct 30 '12 at 08:18

Omar

16,329
10
48
66

Hi Fuex thanks for your reply, actully I am working on a silverlight applcation and I am having the file object in byte[] array. – Rohit Vyas Oct 30 '12 at 09:33
can you show some code which I can use in silverlight applicaiton? – Rohit Vyas Oct 30 '12 at 09:42
Look here for [OpenFileDialog in Silverlight](http://msdn.microsoft.com/en-us/library/system.windows.controls.openfiledialog(v=vs.95).aspx) and use the edited part of my answer to save an image from an array of bytes. – Omar Oct 30 '12 at 15:13

Download file from filestream

3 Answers3