In this article I will explain with an example, how to populate (bind) Repeater control using Stored Procedure in ASP.Net using C# and VB.Net.
Repeater will be populated using Stored Procedure in SQL Server database and will be displayed as HTML table on the page.
 
 
Database
I have made use of the following table Customers with the schema as follows.
Bind (Populate) ASP.Net DropDownList using DataTable (DataSet) in C# and VB.Net
I have already inserted few records in the table.
Bind (Populate) ASP.Net DropDownList using DataTable (DataSet) in C# and VB.Net
 
Note: You can download the database table SQL by clicking the download link below.
          Download SQL file
 
 
HTML Markup
The following HTML Markup consists of an ASP.Net Repeater control. The Repeater control will be rendered as an HTML Table. For more details refer my article Display and render Repeater control as HTML Table Layout in ASP.Net.
<asp:Repeater ID="rptCustomers" runat="server">
    <HeaderTemplate>
        <table cellspacing="0" rules="all" border="1">
            <tr>
                <th scope="col" style="width: 80px">
                    Customer Id
                </th>
                <th scope="col" style="width: 120px">
                    Customer Name
                </th>
                <th scope="col" style="width: 100px">
                    Country
                </th>
            </tr>
    </HeaderTemplate>
    <ItemTemplate>
        <tr>
            <td>
                <asp:Label ID="lblCustomerId" runat="server" Text='<%# Eval("CustomerId") %>' />
            </td>
            <td>
                <asp:Label ID="lblContactName" runat="server" Text='<%# Eval("Name") %>' />
            </td>
            <td>
                <asp:Label ID="lblCountry" runat="server" Text='<%# Eval("Country") %>' />
            </td>
        </tr>
    </ItemTemplate>
    <FooterTemplate>
        </table>
    </FooterTemplate>
</asp:Repeater>
 
 
The Stored Procedure
The following procedure will be used to populate the Repeater control with the records from the Customers table.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[GetCustomers]
AS
BEGIN
      SET NOCOUNT ON;
 
      SELECT CustomerId
            ,Name
            ,Country
      FROM Customers
END
 
 
Namespaces
You will need to import the following namespaces.
C#
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
 
VB.Net
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration
 
 
Populate (Bind) Repeater control using Stored Procedure in ASP.Net
Inside the Page load event handler, the Repeater is populated with the records from the Customers Table using a Stored Procedure.
C#
protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.BindRepeater();
    }
}
 
private void BindRepeater()
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("GetCustomers", con))
        {
            using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
            {
                cmd.CommandType = CommandType.StoredProcedure;
                DataTable dt = new DataTable();
                sda.Fill(dt);
                rptCustomers.DataSource = dt;
                rptCustomers.DataBind();
            }
        }
    }
}
 
VB.Net
Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Me.BindRepeater()
    End If
End Sub
 
Private Sub BindRepeater()
    Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Using con As New SqlConnection(constr)
        Using cmd As New SqlCommand("GetCustomers", con)
            Using sda As New SqlDataAdapter(cmd)
                Dim dt As New DataTable()
                cmd.CommandType = CommandType.StoredProcedure
                sda.Fill(dt)
                rptCustomers.DataSource = dt
                rptCustomers.DataBind()
            End Using
        End Using
    End Using
End Sub
 
 
Screenshot
Populate (Bind) Repeater control using Stored Procedure in ASP.Net using C# and VB.Net
 
 
Demo
View Demo
 
 
Downloads
Download Code