Retrieving images using a file path stored in a sql database (nearly there!)

Question

Ok, I think I am close to making a break through on this.

I have the following code that should, theoretically, populate an image using the file path through a sql database

public void Image1_Load(object sender, EventArgs e)
{
    ////Code to retrieve logo image from tblMemberLogo - Currently does not work!!!

    var connectionstring = ConfigurationManager.ConnectionStrings["PDCConnectionString"].ConnectionString;
    using (var cn = new SqlConnection("Data Source=STRSQL04;Initial Catalog=PDC;Integrated Security=True"))
    using (var cmd = cn.CreateCommand())
    {
        cn.Open();
        cmd.CommandText = "SELECT LogoFilePath FROM tblMemberlogo WHERE MemberID = '123'";
        //cmd.Parameters.Add("123", "5");
        using (var reader = cmd.ExecuteReader())
        {
            if (reader.Read())
            {
                var filepath = reader.GetString(0);
                Image1.ImageUrl = filepath;
                Label2.Text = filepath;
            }
        }
    }
}

Now, I know I am close as the Label2 brings back the appropriate file path for Member 123. However, Image1 still possesses the dreaded red cross. The source code for this Image control is simply the following.

Image ID="Image1" runat="server" Height="71px"  
            Width="400px" onload="Image1_Load"

I will buy whoever helps me get this over the finish one a nice big pint as I am on the verge of having (another) breakdown!!!

Please find below the output html.

img id="Image1" src="file:c:\online%20reporting\SQL%20Solutions\Member%20Logo\123.GIF" style="height:71px;width:400px;border-width:0px;"

Answer 1

I am not sure how your data is stored but in most cases when assigning images server side you need to make sure its relative to the website.

Do this using :

Image1.ImageUrl = Server.MapPath(filepath);

Answer 2

Depending on the Url you may need to use ResolveClientUrl or Server.MapPath

Image1.ImageUrl = ResolveClientUrl(filepath);

OR

Image1.ImageUrl = Server.MapPath(filepath);

Answer 3

Unfortunately, you can't use a "file:" URL as the src of an image. What you need to do is turn that path into a valid HTTP URL.

So if your images are in "c:\online reporting\SQL Solutions", you should add a virtual directory in IIS under your site root that points there, maybe call it "/logos" or something, then you can go:

String fileName = Path.GetFileName(reader.GetString(0)); Image1.ImageUrl = "/logos/" + fileName;

If your web root is already running in, say, "c:\online reporting", it's even easier -- you can skip the virtual directory and just use "/SQL%20Solutions/" as the beginning of the URL.