how to retrive image form database and show in image control in asp.net

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

how to retrive image form database and show in image control in asp.net

i use this for retrive image

C#

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["EatProject"].ToString());

        con.Open();
        string str = "select Name,ImagePath,Link,Status from ImagesPath where ID ='" + DropDownList1.SelectedItem.Text + "'";
        cmd = new SqlCommand(str, con);

        dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            TextBox4.Text = dr["Name"].ToString();
            //Image1.ImageUrl = dr["Imagepath"].ToString();
            TextBox5.Text = dr["Link"].ToString();
            TextBox6.Text = dr["Status"].ToString();
           
        }
        con.Close();

but image is not show in image control

Posted 18-Feb-13 18:34pm

M@anish

Updated 18-Feb-13 19:17pm

Uday P.Singh

v2

Add a Solution

Comments

Nandakishore G N 19-Feb-13 1:34am

are you storing image path or path with the url..i.e, virtual path during development

3 solutions

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)

Avik Ghosh22 · Answer 1 · 2013-02-18T18:48:00

Solution 2

http://www.c-sharpcorner.com/UploadFile/satyapriyanayak/how-to-save-image-along-with-details-into-database-in-asp-ne/[^]

C# Save and Load Image from Database[^]

http://www.aspdotnet-suresh.com/2011/01/how-to-insert-images-into-database-and.html[^]

Posted 18-Feb-13 18:48pm

Avik Ghosh22

Updated 18-Feb-13 18:50pm

v3

nehas1jan · Answer 2 · 2013-02-18T19:13:00

Solution 3

Hi ,

Previewing Image in ASP.NET Image Control using C#[^]

it ll help you.

Posted 18-Feb-13 19:13pm

nehas1jan

Mr. Mahesh Patel · Answer 3 · 2013-02-18T18:40:00

Solution 1

Hi Dear,
Please refer my previous post from below link

How to show images in image control which are all ready present in the database[^]

Posted 18-Feb-13 18:40pm

Mr. Mahesh Patel

Comments

M@anish 19-Feb-13 1:12am

i want show image only in image control not in grideview control image retrieve from database please help me

Mr. Mahesh Patel 19-Feb-13 1:20am

one question is there....

You have stored image bytes or image path in database...?

Mr. Mahesh Patel 19-Feb-13 1:18am

ya, but you can reference this post, do not use complete. this is just guide my dear.

Mr. Mahesh Patel 19-Feb-13 1:19am

other wise you have to store image physically and give path to your image control.