how to show an image in image control retrived path from database and image stored in folder

Question

4.00/5 (1 vote)

See more:

Dear sir,

Here I am working on a asp.net project. I stored my image path in database and image inside a folder named as image. here the image stored successfully but it could not load in an image control.
Here is the code.

C#

if (!string.IsNullOrEmpty(Convert.ToString(dr["imagepath"])))
         {
             Image1.ImageUrl = Convert.ToString(dr["imagepath"]);
         }

Plz help me for shut out this problem.
Thanks & Regards
Bigyan Ranjan Sahoo

Posted 28-Aug-14 1:56am

bigyan sahoo

Add a Solution

Comments

coded007 28-Aug-14 8:07am

do you have image in your specified path?

bigyan sahoo 28-Aug-14 21:37pm

Yes, it is inside image folder in same project location.

2 solutions

Solution 1

You can use Server.MapPath(path) to get correct server path. Try this code.

if (!string.IsNullOrEmpty(Convert.ToString(dr["imagepath"])))
{
    Image1.ImageURL= Server.MapPath(dr["imagepath"].ToString());
}

Posted 28-Aug-14 2:07am

jekin77

Updated 28-Aug-14 3:01am

v6

Comments

bigyan sahoo 28-Aug-14 8:42am

I could not use Imagesource. can you explain briefly, I'm new on this platform.

jekin77 28-Aug-14 8:58am

Oo, sorry - this example is for Windows application.
so, for ASP.NET you should try this

string getPath = dr["getPath"].ToString();
image1.imageURL= Server.MapPath(getPath);

Richard Deeming 28-Aug-14 9:01am

Server.MapPath will return the local file-system path of the image on the server. You cannot use that path as the ImageUrl.

jekin77 28-Aug-14 9:06am

it's correct , or i missunderstoot the location of image ?!?!

Richard Deeming 28-Aug-14 9:09am

Server.MapPath("~/images/image1.jpg") will return something like C:\inetpub\wwwroot\images\image1.jpg.

That will generate an HTML <img> tag with the src attribute set to C:\inetpub\wwwroot\images\image1.jpg.

If the user happens to have a file in that path on their local system, that image will be displayed. It won't be the one you wanted to display, because that's on the server.

If the user doesn't have a file in that location on their local system, then the image will not display.

jekin77 28-Aug-14 9:18am

I don't agree with you, beacouse the MapPath method maps the specified relative or virtual path to the corresponding physical directory on the server not on the local machine.

http://msdn.microsoft.com/en-us/library/ms524632(v=vs.90).aspx

Richard Deeming 28-Aug-14 9:21am

Which is exactly the point I'm making.

It maps to the physical path ON THE SERVER.

The HTML then tells the client to load the image at C:\inetpub\wwwroot\images\image1.jpg.

That path points to the CLIENT file-system, so the client tries to load the image from the local machine.

http://en.wikipedia.org/wiki/File_URI[^]

jekin77 28-Aug-14 9:37am

ok.. you mean that the path should be like this ?
"~/Images/" + fileName

Richard Deeming 28-Aug-14 9:40am

Yes. It needs to be either an app-relative path (starting with "~/"), a site-relative path (starting with "/"), a path relative to the current request (for example, "../images/image1.jpg"), or an absolute path (eg: "http://www.mysite.com/images/image1.jpg").

bigyan sahoo 28-Aug-14 12:07pm

Thanks all of you, due to this conversation I get a briefly idea about upload & retrieve image from client to server.

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)

Richard Deeming · Accepted Answer · 2014-08-28T03:28:00

If the imagepath column contains the name of a file inside the images directory, then it should be as simple as:

C#

Image1.ImageUrl = "~/images/" + Convert.ToString(dr["imagepath"]);

If the column contains the physical path of the file on the server, then it gets more complicated. Assuming everything is within the same physical folder structure, you might be able to use something like this:

C#

string physicalPath = Convert.ToString(dr["imagepath"]);
string imagesPhysicalPath = Server.MapPath("~/images/");

if (physicalPath.StartsWith(imagesPhyisicalPath, StringComparison.OrdinalIgnoreCase))
{
    string relativePath = physicalPath.Substring(imagesPhysicalPath.Length);
    image.ImageUrl = "~/images/" + relativePath.Replace('\\', '/');
}