Bind data at runtime

Question

4.00/5 (1 vote)

See more:

help me for this i have following code and i want to display data at runtime in repeater control...
Here is code behind.

C#

public partial class RepeaterDemo : System.Web.UI.Page
    {
        //string con = ConfigurationManager.ConnectionStrings["connStr"].ToString();
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connStr"].ToString());
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlCommand cmd = new SqlCommand("Select Countryid,CountryName,CountryCode,Status from Country", conn);
            
            DataSet ds = new DataSet();

            SqlDataAdapter da = new SqlDataAdapter();
            
            da.Fill(ds);
            rpt.DataSource = ds;
            rpt.DataBind();
        }
    }

here is designer code

XML

<asp:Repeater ID="rpt" runat="server">
            <HeaderTemplate>
                Country Table Data<br />
                <br />
            </HeaderTemplate>
            <ItemTemplate>
                <table border="2px"><tr><td>
                Country ID:</td><td width="50%">
                <%#Eval("Countryid") %></td></tr>
                <tr ><td>
                Country Name :</td><td width="50%">
                <%#Eval("CountryName") %></td></tr>
                <tr ><td width="50%">
                Country Code :</td><td>
                <%#Eval("CountryCode") %></td></tr>
                <tr ><td width="50%">
                Status :</td><td>
                <%#Eval("Status") %></td>
                </tr></table>
            </ItemTemplate>
            
            <FooterTemplate>Showing Country Table Data.</FooterTemplate>
            <SeparatorTemplate>

            </SeparatorTemplate>
        </asp:Repeater>

how can i bind data at page load event??

Thanks in advance.

Posted 7-Aug-12 23:17pm

Ritesh Rana

Updated 7-Aug-12 23:19pm

Prasad_Kulkarni

v2

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Amy · Accepted Answer · 2012-08-07T23:27:00

Solution 1

Hi,
Follow the links below:
A Grouping Repeater Control for ASP.NET[^]
Nesting data bound (Repeater) controls in ASP.NET[^]
A NestedRepeater Control for ASP.NET[^]
A quick guide to using nested repeaters in ASP.NET[^]A Typed Repeater in ASP.NET[^]

--Amit

Posted 7-Aug-12 23:27pm

_Amy

Prabhakaran Soundarapandian · Accepted Answer · 2012-08-07T23:31:00

Solution 2

Check this Link 1 and Link 2 it will be useful for you...

Posted 7-Aug-12 23:31pm

Prabhakaran Soundarapandian

Comments

Ritesh Rana 8-Aug-12 5:46am

great...thanks

Prabhakaran Soundarapandian 8-Aug-12 5:50am

If you find as useful..choose this as answer...

Ganesh Nikam · Accepted Answer · 2012-08-08T00:07:00

hiii,
this is sample code

XML

Add a Repeater on the design page:

<asp:Repeater ID="Repeater1" runat="server">
<HeaderTemplate>
<table cellpadding="5" cellspacing="2" >
<tr bgcolor=Gray>
<td><b>Name</b></td>
<td><b>Country</b></td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td><%# DataBinder.Eval(Container.DataItem,"Name") %></td>
<td><%# DataBinder.Eval(Container.DataItem,"Country") %></td>
</tr>
</ItemTemplate>
<AlternatingItemTemplate>
<tr bgcolor="#ccccff">
<td><%# DataBinder.Eval(Container.DataItem,"Name") %></td>
<td><%# DataBinder.Eval(Container.DataItem,"Country") %></td>
</tr>
</AlternatingItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>

On code page write the following code on page Load:-

DataSet ds = new DataSet();
DataTable dt = ds.Tables.Add("Employee");
dt.Columns.Add("Name", Type.GetType("System.String"));
dt.Columns.Add("Country", Type.GetType("System.String"));
DataRow dr = dt.NewRow();
dr[0] = "amit";
dr[1] = "India";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "rajinder";
dr[1] = "SriLanka";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "parmod";
dr[1] = "UK";
dt.Rows.Add(dr);
Repeater1.DataSource = ds;
Repeater1.DataMember = "Employee";
Repeater1.DataBind();

Bind data at runtime

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Bind data at runtime

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us