Link to home
Start Free TrialLog in
Avatar of msout
msout

asked on

Display Images in DataList Control using the path stored in SQL Server database

I try to Display Images in DataList Control using the path stored in SQL Server database.
The images stored in the separate folder called "Images" on web server & I store the image path in the Database

I use sqldatasource to show the data:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:BLSDBConnectionString1 %>"
            SelectCommand="SELECT * FROM [Employees] ORDER BY [LastName]">
        </asp:SqlDataSource>
I can show images in the gridview but on the web page we need to show three images in the row. So I need to use datalist and not the gridview.
 This is my code:
<asp:DataList ID="dtList"
            runat="server"  
            DataSourceID="SqlDataSource1"
            HorizontalAlign="Justify"
            RepeatColumns="3"
            RepeatDirection="Horizontal" >
           
            <ItemTemplate>
                EmployeeId:
                <asp:Label ID="EmployeeIdLabel"
                    runat="server"
                    Text= '<%#DataBinder.Eval(Container.DataItem, "EmployeeId")%>'></asp:Label>
                <br />
                FirstName:
                <asp:Label ID="FirstNameLabel"
                    runat="server"
                    Text='<%#DataBinder.Eval(Container.DataItem,"FirstName") %>' />
                <br />
                MidInit:
                <asp:Label ID="MidInitLabel"
                    runat="server"
                    Text='<%#DataBinder.Eval(Container.DataItem,"MidInit") %>' />
                <br />
                LastName:
                <asp:Label ID="LastNameLabel"
                    runat="server"
                    Text='<%#DataBinder.Eval(Container.DataItem,"LastName") %>' />
                <br />
                Unit:
                <asp:Label ID="UnitLabel"
                    runat="server"
                    Text='<%#DataBinder.Eval(Container.DataItem,"Unit") %>' />
                <br />
                PictureFileName:
                <asp:Label ID="PictureFileNameLabel" runat="server"
                    Text='<%#DataBinder.Eval(Container.DataItem,"PictureFileName") %>' />
                <br />
                <asp:Image ID="ImageID" runat="server" Width="100px"
                   
                    ImageUrl='<%# Eval("ImagePath") %>' />                
      </ItemTemplate>          
        </asp:DataList>
All records show except the image. It is empty.
How can I correct it?
Please, help.
ASKER CERTIFIED SOLUTION
Avatar of Paul MacDonald
Paul MacDonald
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of msout
msout

ASKER

Thank you, I found out that the ImagePath in db was not written right. Now I have to resolve one more problem.
 images/Aaron Bitler.jpg - this is the ImagePath. I cannot delete the extension - .jpg because it won't show the picture. How can I show only the picture without the   "images/Aaron Bitler.jpg "
Avatar of msout

ASKER

Never mind! I just deleted hiperlink and it shows only a picture!
Great!  Happy to help.