在运行时绑定数据

问题描述:

为此,请帮我,我有以下代码,我想在中继器控制下在运行时显示数据...
这是后面的代码.

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

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

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


请点击以下链接:
用于ASP.NET的分组转发器控件 [ ^ ]
在ASP.NET中嵌套数据绑定(Repeater)控件 [ ^ ]
用于ASP.NET的NestedRepeater控件 [在ASP中使用嵌套转发器的快速指南. NET [ ^ ] ASP中的类型化中继器.NET [ ^ ]



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


检查此链接1 链接2 ,它将对您有用...
Check this Link 1 and Link 2 it will be useful for you...


hiii,
这是示例代码

hiii,
this is sample code

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();