Data Repeater in ASP.NET

Question

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 ****************

Satyapriya Nayak · Answer

Hi Siri For displaying data in the repeater you have to mention it in item template as Try this... Untitled Page 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

siri · Answer

thanku satyapriyaji :)))))

Vulpes · Answer

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