在运行时绑定数据
问题描述:
为此,请帮我,我有以下代码,我想在中继器控制下在运行时显示数据...
这是后面的代码.
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();