Data Repeater in ASP.NET

siri

14y4.3k.NET

I did sample example using data repeater in ASP dot net using vb code ...

as iam not getting data frm my table plz can anyone tell y iam not getting data frm table as it showing only table header.....

as my vb code....

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If cn.State = ConnectionState.Closed Then cn.Open()
sqlquery = "select * from Main_tbl "
cmd = New SqlCommand(sqlquery, cn)
adap = New SqlDataAdapter(cmd)
adap.Fill(dt)

If dt.Rows.Count Then
Repeater1.DataSource = dt
Repeater1.DataBind()
End If

End Sub

****************

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak14y ago
Accepted answer
Hi Siri,

For displaying data in the repeater you have to mention it in item template as

<%#Container.DataItem("SchoolNumber")%>
<%#Container.DataItem("AccountNumber")%>
<%#Container.DataItem("LastName")%>
<%#Container.DataItem("ZipCode")%>

Try this...

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

    Untitled Page







<%#Container.DataItem("SchoolNumber")%> <%#Container.DataItem("AccountNumber")%> <%#Container.DataItem("LastName")%> <%#Container.DataItem("ZipCode")%>





Imports System.Data.SqlClient
Imports System.Data
Partial Public 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 Main_tbl"
            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

Thanks
If this post helps you mark it as answer
siri14y ago
thanku satyapriyaji :)))))
Vulpes14y ago
The overload of the SqlDataAdapter.Fill method that takes a DataTable as a parameter only obtains the first result.

Instead of filling the DataTable, I'd try filling the whole DataSet and then binding to the DataTable from that.

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If cn.State = ConnectionState.Closed Then cn.Open()
sqlquery = "select * from Main_tbl "
cmd = New SqlCommand(sqlquery, cn)
adap = New SqlDataAdapter(cmd)
adap.Fill(ds) ' fill dataset here

If dt.Rows.Count Then
Repeater1.DataSource = ds.Tables(0) 'bind to first datatable in dataset
Repeater1.DataBind()
End If

End Sub