How to Convert BinaryData to File in C#?

Question

Actually I have saved some files like .pdf,.txt,.doc,.xls by converting them to <Binary data> in my SQL SERVER DB through FileUploadControl. Now, I want to Convert the <Binary data> back to Normal and give an option for user to Download (or) View that data.

I have tried some thing like this for the .txt files

var filedata = (from xx in VDC.SURVEY_QUESTION_REPLIES
                                    where xx.ID == FileID
                                    select xx).FirstOrDefault();

string fileextension = filedata.FILE_EXTENSION.ToString();
string fileName = filedata.ANSWER_TEXT.ToString() + fileextension;
Byte[] bytes = (Byte[])filedata.FILE_DATA;
Response.Buffer = true;
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8));
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();

I am getting an error like :

Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack.

If Possible can you suggest any other process of doing this? — RealSteel, Jul 31 '13 at 08:14

Ishtiaq · Answer 1 · 2013-07-31T07:29:48.807

0

You can try this sample for saving PDF file.

byte[] binaryData = (byte[])filedata.FILE_DATA;

`File.WriteAllBytes("file.pdf", binaryData);`

edited Jul 31 '13 at 07:29

answered Jul 31 '13 at 07:17

Ishtiaq

980
2
6
21

score 0 · Answer 2 · answered Jul 31 '13 at 07:35

0

Is the datatype System.Data.Linq.Binary then you could do something like:

byte[] bytes = filedata.FILE_DATA.ToArray();

Regards.

answered Jul 31 '13 at 07:35

Amc Amsterdam - Netherlands

121
4

How to Convert BinaryData to File in C#?

2 Answers2