ASP.Net Repeater Control Using C#

Yatendra Sharma
Jun 02, 2015
17.9k
0
0
Article

The main use of Repeater Control is for displaying a repeated list of items bound to the control. A Repeater Control is faster and lightweight for displaying data compared to a GridView or DataGrid. With the Repeater control we can display data in a custom format. The main drawback of a Repeater Control is that it doesn't support paging and sorting.

The Repeater Control has the following types of template fields:

Item Template
AlternatingItem Template
Header Template
Footer Template
Separator Template

Item Template

The Item Template is useful for describing how each item will be rendered from the data source collection.

AlternatingItem Template

The AlternatingItem Template describes the markup for each item in the Repeater Control but for the AlternatingItems from the DataSource Collection such as different color and styles in the Repeater Control.

HeaderTemplate

The HeadderTemplate is basically useful for displaying a footer element for the DataSource Collection.

Footer Collection

The Footer Collection is useful for displaying a footer element for the DataSource Collection.

SeparatorTemplate

The SeparatorTemplate describes or determines the separator element that separates each item.

Step 1

Start Visual Studio.

Figure 1: Start Visual Studio

Step 2

Now we need to create a website using "File" -> "New" -> "Website".

Figure 2: Create Website

Step 3

Now, select the ASP.NET Empty Website and click on the Ok button.

Figure 3: ASP.NET Empty Website

Step 4

Now, add the Web form by right-clicking on the website and provide a name for the web form.

Figure 4: Add the Web Form

Step 5

Now we need to create a table in the SQL Server.

create table Student_Details1(S_ID int Primary key, Student_name Varchar(50),Register_No int,D_O_B date, D_O_E date,Department varchar(50));

Now we will insert the data into the Student_Details table.

insert into Student_Details1 values(1,'yatendra',120,'1992-10-10','2013-12-10','MCA');
insert into Student_Details1 values(2,'Rahul',125,'1993-05-07','2013-12-10','MBA');
insert into Student_Details1 values(3,'sachin',120,'1992-08-02','2013-12-08','B-Tech');
insert into Student_Details1 values(4,'Rohit',120,'1992-05-15','2013-12-10','MCA');

Step 6

Now we will write the following code for the Default.aspx form.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Repeater</title>
</head>
<body>
<form id="form1" runat="server">
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<div>
<table>
<tr>
<th>Student<%#Eval("S_ID")%></th>
</tr>
<tr>
<td>Student Name</td>
<td><%#Eval("Student_Name")%></td>
</tr>
<tr>
<td>Registration Number</td>
<td><%#Eval("Register_No")%></td>
</tr>
<tr>
<td>Date Of Birth</td>
<td><%#Eval("D_O_B")%></td>
</tr>
<tr>
<td>Date Of Examination</td>
<td><%#Eval("D_O_E")%></td>
</tr>
<tr>
<td>Department</td>
<td><%#Eval("Department")%></td>
</tr>
</table>
</div>
</ItemTemplate>
</asp:Repeater>
</form>
</body>
</html>

Step 7

Now we will write the following code for the page_load.

protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=MCNDESKTOP34;Initial Catalog=yatendra;Persist Security Info=True;User ID=sa;
Password=Password$2");
SqlDataAdapter sda = new SqlDataAdapter("select * from Student_Details1",con);
DataTable dt = new DataTable();
sda.Fill(dt);
Repeater1.DataSource = dt;
Repeater1.DataBind();
}