在运行时绑定数据

问题描述

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

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.

推荐答案

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

这篇关于在运行时绑定数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！