C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...






Forums » .NET » ASP.NET »

How to show data in repeater control?


Posted Date: 05 Jul 2008      Posted By: Red Swan      Member Level: Gold     Points: 1   Responses: 4



I write this code for repeater control. But when i click the button data can not found .Also used table has the data. why should i can't show it? Is any property remain to set?


protected void Button2_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=PMTSDATASERVER;Initial Catalog=ParallelMindsDB;Integrated Security=True");
string qry = "Select * from ProductRating";
SqlCommand cmd = new SqlCommand(qry, con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
Repeater1.DataSource = rdr;
Repeater1.DataBind();
}





Responses

Author: Nalin    05 Jul 2008Member Level: GoldRating: 2 out of 52 out of 5     Points: 1

see this site
http://www.sitepoint.com/article/asp-net-repeater-control



Author: Sujit Kumar    05 Jul 2008Member Level: DiamondRating: 2 out of 52 out of 5     Points: 6

you have to make template to show data in repeter like:

<asp:Repeater ID="rpTest" runat="server">
<HeaderTemplate>
<table>
<tr>
<td>Header Text</td>
<td>Emp Code</td>
<td>Emp Name</td>
<td>PubID</td>
<td>Link</td>
</tr>
</table>
</HeaderTemplate>
<ItemTemplate>
<table>
<tr>
<td><b>Visitor : </b><%= i %></td>
<td><%#DataBinder.Eval(Container.DataItem,"Emp_ID")%></td>
<td><%#DataBinder.Eval(Container.DataItem,"Emp_Name")%></td>
<td><%#DataBinder.Eval(Container.DataItem,"Pub_Id")%></td>
<td><a href="Default2.aspx?ID=<%#DataBinder.Eval(Container.DataItem,"pub_ID")%>&count=<%= i %>">VISIT</a></td>
<%--<a href="LifeBreakup.aspx?CID=<%#DataBinder.Eval(Container.DataItem,"ICID")%>&CNID=<%=ClientID%>">--%>
</tr>
</table>
</ItemTemplate>
</asp:Repeater>

now you can bind data in repeter like you have already done.


protected void Button2_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=PMTSDATASERVER;Initial Catalog=ParallelMindsDB;Integrated Security=True");
string qry = "Select * from ProductRating";
SqlCommand cmd = new SqlCommand(qry, con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
Repeater1.DataSource = rdr;
Repeater1.DataBind();
}



Author: tushqi    05 Jul 2008Member Level: SilverRating: 2 out of 52 out of 5     Points: 6

<asp:Repeater ID="catlist" runat="server">
<HeaderTemplate>
<tr>
<td class="imgspace">
<img src="Images/areas.jpg" width="91" height="28" class="bigtext">
</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td>
<div align=center>
<asp:HyperLink class="text"
NavigateUrl="<%# "mainframeset.aspx?CatType=" +
DataBinder.Eval(Container.DataItem,"Sub_Category_ID")%>"
Text="<%#DataBinder.Eval(Container.DataItem, "Sub_Category_Text")%>"
runat="server" target="mainFrame" ID="Hyperlink1" NAME="Hyperlink1"/>
<br></div>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
<tr>
<td>
</td>
</tr>
</FooterTemplate>
</asp:Repeater>



Author: Nithya    07 Jul 2008Member Level: GoldRating: 2 out of 52 out of 5     Points: 2

refer the following link

http://www.w3schools.com/ASPNET/aspnet_repeater.asp

Tnsnks & Regrds.
Nithya



Post Reply

 This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.


Next : How to checked checkbox value by httpwebrequest or webclient
Previous : Repeater problem
Return to Discussion Forum
Post New Message
Category: ASP.NET

Related Messages



dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use