I am storing images in a "images" file within my project. THe file then has subfiles based on "PropertyID". I only want to retrieve the main photo, which will be named "1001_Main". So the path would look something like : /images/1001/1001_Main (there
are multiple properties.... 1002, 1003, 1004, etc)
I need to retrieve the image based on a "PropertyID" that is done in a query. My query is here:
string sSQL = @"SELECT PropId, address, city, state, zip, price, bedrooms, baths
FROM Properties
WHERE (properties.available = 'Y')";
DataTable dtProps = new DataTable();
The information will be displayed in a Repeater like this:
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
< ...
Go to the complete details ...