How to Download a .pdf/.txt/.jpeg from sql server database.

Question

0.00/5 (No votes)

See more:

Hi,

I want to design a usercontrol where the user will be able to upload a file(.pdf/.txt/.jpeg)-which i was able to build using FileUpload control, but my problem is how to build a control where the user can see a list of uploaded file and click on it to download it. I am using Linq2Sql and have a table with a column Asset as byte[] to store the uploaded files.

I need sample Markup and Code Behind that can help me achieve this.

Thank you,

Chetan.

Posted 7-Jul-11 10:44am

cnjadhav

Updated 7-Jul-11 14:42pm

fjdiewornncalwe

v2

Add a Solution

Comments

Member 10658172 10-Mar-14 10:39am

i want code and form design for file upload and download

2 solutions

Solution 2

i able to design the form in file upload who to write code for it

Posted 10-Mar-14 4:46am

Member 10658172

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Accepted Answer · 2011-07-07T10:49:00

Solution 1

You read the bytes from the DB and use Response.BinaryWrite to send the file down, making sure you set the header as well.

VB

Response.ClearContent()
                  Response.ClearHeaders()
                  Response.AddHeader("Content-Length", b.Length.ToString)
                  Response.ContentType = ContentType
                  Response.BinaryWrite(b)
                  Response.Flush()
                  Response.Clear()

Something like that, where b is your array of bytes.

Posted 7-Jul-11 10:49am

Christian Graus

Comments

cnjadhav 7-Jul-11 16:56pm

can you explain me the following:
Response.AddHeader("Content-Length", b.Length.ToString)
and what control do you suggest for frontend(hyperlink/Gridview)?

Christian Graus 7-Jul-11 20:50pm

You can use any control you want. b is a byte array. That line is telling the Response object to write the length of the file being downloaded. This is VB.NET, so add semicolons to make it C# :-)

cnjadhav 8-Jul-11 12:25pm

how do i call the array of bytes, from a method like Employee.GetAll() with the column with bytes is EmployeePicture???

cnjadhav 8-Jul-11 12:28pm

i mean how do i use FileInfo or the DirectoryInfo(server.MapPath(????callthebytearray)) to get the array of bytes?