bind expression problem

Question

I want to show a collection of images in list view.

I have an image table in a MySQL database, the fields are photoId, PhotoName, ...

I want to bind the image control Url in the item template of the list view on the physical path (stored in config file) + photoName in the DB.

ImageUrl ='<%# ConfigurationManager.AppSettings.GetValues("ThePath").First() + 
    "\\" + "News Images" + "\\" + "Unit #" + Session["UserData"].ToString() + 
    "_" +"News #"+ NewsIdTextBox.Text + "\\"+Eval("photoName") %>' 

but it doesn't work, no photos appeared, only the photos names.

I tried to store the path in the database but it throws an exception.

Answer 1

I dont really understand what you are trying to do but if you trying to create a url, you need to start using forward slashes instead of back slashes and remove spaces from your path.

Answer 2

just-name, where do you store your images, in database or in the folder/filepath? Do your images exist in the ImageUrl filepath? The method you are using won't work if you want to retrieve images from database. The control will try to retrieve the images from the ImageUrl filepath, and (possibly) throw an exception when the image file does not exist.

Answer 3

Image's url should point to web path because client loads it, not server, i.e. http://example.com/images/logo.png but not d:\www\example.com\images\logo.png because client's browser will try to load this images from user's computer while it doesn't exist of course. And encode resulting string, i.e. replace spaces with %20, so on.

Otherwise, if you want to create a path to load the image by server-side, it's ok.