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.
Web DevelopmentASP.NET

Avatar of undefined
Last Comment
Paul MacDonald
ASKER CERTIFIED SOLUTION
Avatar of Paul MacDonald
Paul MacDonald
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
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
msout

ASKER

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

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

128K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo