How to display an Image with a fixed size, fetched from the Database in ASP.NET

Question

My Table in the Database contains a column with a type : image.

I have managed to upload the image to the database.

But almost all tutorials out there, shows us how to give the Image Controller a URL which contains the name of the page, plus a parameter that has the ID of the selected row in the Database

Example:

//Database codes here... (query..etc..)
SqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.HasRows == true)
{
    myReader.Read();
    Response.ContentType = "image/jpg";
    Response.BinaryWrite((byte[])myReader[0]);
    Image1.ImageUrl="User.aspx?imgid=1";
}

So when I click on a specific button which should fetch this image from the database, then give that URL to the image, the image opens in full screen.. But I don't want that, let's say I have empty space in my page for an Image of 50px width and 50px height, how can I show the image inside this space? and keeping all the other contents? just like a user page, a profile page.

This is almost the same, you just not make them thumbnails stackoverflow.com/questions/13988269/… — Aristos
– Aristos, Commented Dec 21, 2012 at 23:55

Scott Mitchell · Accepted Answer · 2012-12-22 00:00:41Z

3

You can control the image's display using an <img> tag. So say your ASP.NET page that gets and displays the image is called ShowImage.aspx?ID=xxx.

Create a new page named ShowImageAt50px.aspx and in that page add the following markup:

<img src="ShowImage.aspx?ID=xxx" style="width:50px;" alt="" />

Now when you visit ShowImageAt50px.aspx it will show the image constrained at 50 pixels wide.

answered Dec 22, 2012 at 0:00

Scott Mitchell

8,7594 gold badges57 silver badges73 bronze badges

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

2 Comments

user1665700 Over a year ago

Is this the "official" way of fetching and displaying images from the database?

Scott Mitchell Over a year ago

Yes. If you are using ASP.NET WebForms consider using an <asp:Image> tag, but regardless, the result is an <img> tag with a reference to an ASP.NET page that fetches and returns the image content in the DB.

Lee Taylor · Accepted Answer · 2012-12-21 23:43:24Z

-1

It's usually far easier and less error-prone to store your images in the file-system and refer to your images in the database using the filenames of your images.

I've never come across a good reason to store images in a database.

Also, when you want to edit your image that's stored in the database, then you are going to have to export it out of your database and then reimport it back in.

answered Dec 21, 2012 at 23:43

Lee Taylor

7,99416 gold badges38 silver badges53 bronze badges

9 Comments

user1665700 Over a year ago

I've divided my Images into 2 Categories. Public images, that are stored in a folder. (Easy to use) Private images, user specific images that I feel that I should upload to the database to prevent other users from simply reaching them. Am I wrong?

Lee Taylor Over a year ago

If you gave your private images a filename of random characters, e.g. RTWQ2312.jpg, then how would these be found?

user1665700 Over a year ago

Random Characters or not, won't they be stored in a folder? can't they access this folder?

Lee Taylor Over a year ago

They can't list the contents of the folder. Unless you've got your permissions set up incorrectly on your web server...

Steve's a D Over a year ago

There are both pros and cons to storing images in a db vs file system. Anybody who claims one way is right is wrong. stackoverflow.com/questions/2517752/…

|

Collectives™ on Stack Overflow

How to display an Image with a fixed size, fetched from the Database in ASP.NET

2 Answers 2

2 Comments

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related