本文介绍了在运行时绑定数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
为此,请帮我,我有以下代码,我想在中继器控制下在运行时显示数据...
这是后面的代码.
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();
这篇关于在运行时绑定数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!