Repeater control in VB.NET
In this article, We will see how to use Repeater control in VB.NET.
In this article, We will see how to use Repeater control in VB.NET.The repeater control is used to display the data in list.The repeater control like the HeaderTemplate, ItemTemplate, AlternatingItemTemplate and FooterTemplate etc.
This code is aspx:-
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="RepeaterControl.aspx.vb"
Inherits="RepeaterControl" %>
<!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> Repeater Control </title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Repeater ID="RepeaterControl" runat="server">
<HeaderTemplate>
<table border="1" width="100%">
<tr>
<th>
StId
</th>
<th>
StudentName
</th>
<th>
ClassName
</th>
<th>
RollNo
</th>
<th>
EmailId
</th>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td>
<%#DataBinder.Eval(Container.DataItem, "StId")%>
</td>
<td>
<%#DataBinder.Eval(Container.DataItem, "StudentName")%>
</td>
<td>
<%#DataBinder.Eval(Container.DataItem, "ClassName")%>
</td>
<td>
<%#DataBinder.Eval(Container.DataItem, "RollNo")%>
</td>
<td>
<%#DataBinder.Eval(Container.DataItem, "EmailId")%>
</td>
</tr>
</ItemTemplate>
<AlternatingItemTemplate>
<tr>
<td>
<%#DataBinder.Eval(Container.DataItem, "StId")%>
</td>
<td>
<%#DataBinder.Eval(Container.DataItem, "StudentName")%>
</td>
<td>
<%#DataBinder.Eval(Container.DataItem, "ClassName")%>
</td>
<td>
<%#DataBinder.Eval(Container.DataItem, "RollNo")%>
</td>
<td>
<%#DataBinder.Eval(Container.DataItem, "EmailId")%>
</td>
</tr>
</AlternatingItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
</div>
</form>
</body>
</html>
This code is .vb:-
Imports System.Data
Imports System.Configuration
Imports System.Collections
Imports System.Web
Imports System.Web.Security
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.WebControls.WebParts
Imports System.Web.UI.HtmlControls
Imports System.Data.SqlClient
-------------------------------------------------------------------------------------------------------
Partial Class RepeaterControl
Inherits System.Web.UI.Page
Private sqlDataAdapter As Data.SqlClient.SqlDataAdapter
Private dataSet As New Data.DataSet()
Private sqlConnection As Data.SqlClient.SqlConnection
Private sqlCommand As New Data.SqlClient.SqlCommand()
Private mycdcatalog As New DataSet()
-------------------------------------------------------------------------------------------------------
Protected Sub RepeaterControl_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles
RepeaterControl.Load
sqlConnection = New Data.SqlClient.SqlConnection(ConfigurationManager.AppSettings("connect"))
sqlCommand.CommandText = "Select * From StudentRecords"
sqlCommand.Connection = sqlConnection
sqlDataAdapter = New Data.SqlClient.SqlDataAdapter(sqlCommand)
sqlDataAdapter.Fill(dataSet)
sqlConnection.Open()
sqlCommand.ExecuteNonQuery()
RepeaterControl.DataSource = dataSet
RepeaterControl.DataBind()
sqlConnection.Close()
End Sub
End Class
-------------------------------------------------------------------------------------------------------
Output:-