</head>
<body>
<form id="form1" runat="server">
<div>
</div

<asp:DataList ID="DataList1" runat="server">
<FooterStyle BackColor="#FFCC00" ForeColor="#FF3300" />
<EditItemStyle BackColor="#FF8080" />
<AlternatingItemStyle BackColor="#FFFF99" />
<HeaderTemplate>
<center><b>Student Details</b></center>
</HeaderTemplate>
<ItemTemplate>
<table border="1">
<tr>
<th>sid</th>
<th>sname</th>
<th>saddress</th>
<th>smarks</th>
<th>pic</th>
</tr>
<tr>
<td><%#Container.DataItem("sid")%></td>
<td><%#Container.DataItem("sname")%></td>
<td><%#Container.DataItem("saddress")%></td>
<td><%#Container.DataItem("smarks")%></td>
<td><asp:Image ID="Image1" ImageUrl='<%#container.dataitem("pic")%>'runat="server" /></td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>
</form>
</body>
</html>

Default.aspx.vb code

Imports System.Data.SqlClient
Imports System.Data

Partial Class _Default
Inherits System.Web.UI.Page
Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString").ToString()
Dim con As New SqlConnection(strConnString)
Dim com As SqlCommand
Dim str As String
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) HandlesMe.Load
If Not IsPostBack Then
con.Open()
Str = "select * from student"
com = New SqlCommand(Str, con)
Dim reader As SqlDataReader
reader = com.ExecuteReader
DataList1.DataSource = reader
DataList1.DataBind()
reader.Close()
con.Close()
End If
End Sub
End Class

Output

Display Picture in DataList in VB.NET

Reactions

Program

Default.aspx code

Comments

Output