Display data in a Repeater control

Posted by Saranya Boopathi under ASP.NET on 6/26/2013 | Points: 10 | Views : 855 | Status : [Member] | Replies : 1
Which template must you provide, in order to display data in a Repeater control?

Saranya Boopathi


Posted by: Satyapriyanayak on: 6/27/2013 [Member] [MVP] Silver | Points: 25

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>
<form id="form1" runat="server">
<asp:Repeater id="Repeater1" runat="server">
<table border="1">
<td><asp:Image ID="Image1" ImageUrl='<%#container.dataitem("pic")%>' runat="server" /></td>

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
str = "select * from student"
com = New SqlCommand(Str, con)
Dim reader As SqlDataReader
reader = com.ExecuteReader
Repeater1.DataSource = reader
End If
End Sub
End Class

If this post helps you mark it as answer

Saranya Boopathi, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response