Downloading BLOB file from Mysql using Aspx

Question

We are storing file as BLOB in mysql with its filename also.While uploading its working fine. Now we want to download it fron gridview this also works perfect. But the problem is that after downloading the fine when we try to open it it shows file format error. We are only dealing with office document and pdf only.

try
{
  int did = Convert.ToInt32(e.CommandArgument);
  DataSet path = download.GetresourcePath(did);
  byte[] fileFromDatabase = null;
  DataRow row = path.Tables[0].Rows[0];
  fileFromDatabase = (byte[])row["UPLFILE"];
  string filename = (string)row["FILENAME"];

  if (fileFromDatabase.Length > 0)
  {
    Response.Clear();
    Response.Buffer = true;
    Response.ContentType = string.Format("application/{0}",
      Path.GetExtension(filename).Substring(1));
    Response.AddHeader("content-disposition", 
      string.Format("attachment;filename={0}", filename));
    Response.BinaryWrite(fileFromDatabase);
    Response.Flush();
    Response.End();
  }
}
catch (Exception)
{
  return;
}

Here did is the ID of the file we getting it from the grid view.
filename is the name of the file we are getting from the database.
fileFromDatabase is the BLOB file from Mysql and we converted it into Byte.

So can any one suggest me what i am doing wrong?

KV Prajapati · Accepted Answer · 2012-05-11 07:23:51Z

1

Try to remove the headers entries and add it manually.

 Response.Clear();
 Response.ClearHeaders();
 Response.AddHeader("Content-Type", "application/octet-stream");
 Response.AddHeader("Content-Length", fileFromDatabase.Length.ToString());
 Response.AddHeader("Content-Disposition",string.Format("attachment;filename={0}", filename));
 Response.BinaryWrite(fileFromDatabase);
 Response.Flush();
 Response.End();

answered May 11, 2012 at 7:23

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Aaraadhana Over a year ago

sorry it giving same error while opening the file after it has been download.

KV Prajapati Over a year ago

@Aaraadhana - May be the content of file is saved incorrectly. Try to save the content of BLOB field into disk file and open it.

Aaraadhana Over a year ago

The file got corrupted.Thanks

David Robertson · Accepted Answer · 2012-05-11 07:15:16Z

0

I suggest that you don't store files as BLOBs. It is very bad for performance, if nothing else.

You should store the files in the server's filesystem, and in the database store the path to the file.

answered May 11, 2012 at 7:15

David Robertson

1,8393 gold badges12 silver badges12 bronze badges

1 Comment

Aaraadhana Over a year ago

The file size will be maximum 4MB. Any way can you tell me why its showing file format error.

Collectives™ on Stack Overflow

Downloading BLOB file from Mysql using Aspx

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related