.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Post New Resource Bookmark and Share   

Display Picture In Repeater

Posted By:satyapriyanayak       Posted Date: March 25, 2013    Points: 40    Category:    URL: http://www.dotnetspark.com  

Display Picture In Repeater
 

First create a table student

Create table student (sid varchar(50),sname varchar(50),saddress varchar(50), smarks int,pic varchar (50))

 

Store the picture in the program folder and save there name in pic column of the table with there extension like (.gif,.jpg,.bmp)

 

Default.aspx code

 

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

 

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title>Untitled Page</title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

       <asp:Repeater id="Repeater1" runat="server">

                        <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:Repeater>

    </div>

    </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) Handles Me.Load

        If Not IsPostBack Then

            con.Open()

            str = "select * from student"

            com = New SqlCommand(Str, con)

            Dim reader As SqlDataReader

            reader = com.ExecuteReader

            Repeater1.DataSource = reader

            Repeater1.DataBind()

            reader.Close()

            con.Close()

        End If

    End Sub

End Class