Show image from database using filepath asp.net and C#

Question

I am trying to show image on the label retrieved from the database. My front end code is

<asp:Image ID="Image1" runat="server" Height="150px" Width="120px" />

where as my backend code is:

  string query = "select quantity, name, price, description, type, Catagory, FilePath from product where p_id ='" + IdList.SelectedValue + "'  ";
            con.Open();
            SqlCommand cmd = new SqlCommand(query, con);
            SqlDataReader rdr = cmd.ExecuteReader();

            if(rdr.HasRows)
            {
                while (rdr.Read())
                {  string filename1 = rdr.GetString(6);
                    Image1.ImageUrl="C:\\Users\\Fatima\\Downloads\\db-final-project\\db final project\\db final project\\UploadedImages\\"+filename1; }

kindly help me in displaying my image in label in the web form

what is the value of filename1 ?

Pranav Patel
– Pranav Patel

2016-05-26 07:36:16 +00:00
Commented May 26, 2016 at 7:36 — Pranav Patel
– Pranav Patel, Commented May 26, 2016 at 7:36
its the name of image retrieved from database

SmartF
– SmartF

2016-05-26 07:41:57 +00:00
Commented May 26, 2016 at 7:41 — SmartF
– SmartF, Commented May 26, 2016 at 7:41

ShayLivyatan · Accepted Answer · 2016-05-26 07:49:58Z

1

"C:\Users\Fatima\Downloads\db-final-project\db final project\db final project\UploadedImages\" is not a valid URL. Image1.ImageUrl expects a URL, like "http://www.SomeSite.com/someImage.jpg", and not a local directory on your hard-drive.

Put those pictures in your database (there should be a table column of type 'image' which can store images) or better yet - add it as an asset to your project and link to its relative path (e.g., the path in which your site/application resides in, without the domain name).

You can see a valid usage of Image.ImageUrl in here: https://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.image.imageurl.aspx

answered May 26, 2016 at 7:49

ShayLivyatan

1137 bronze badges

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

Collectives™ on Stack Overflow

Show image from database using filepath asp.net and C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related