绑定内部中继器
本文关键字:中继器 内部 绑定 | 更新日期: 2023-09-27 18:35:49
我有以下中继器:
<asp:Repeater ID="repeater1" runat="server" OnItemDataBound="repeater1_ItemDataBound">
<HeaderTemplate>
...
</HeaderTemplate>
<ItemTemplate>
<tr>
<td>
<asp:Label runat="server" Text='<%#Eval("id")%>'> </asp:Label></td>
<td>
<asp:Label runat="server" Text='<%#Eval("ssdvalue")%>'></asp:Label>
</td>
<td>
<asp:Repeater runat="server" ID="repeater2">
<ItemTemplate>
<asp:Label Text='<%#Eval("stptime")%>' runat="server"></asp:Label>
</ItemTemplate>
</asp:Repeater>
</td>
</tr>
</ItemTemplate>
</asp:Repeater>
现在在上面的代码中有两个中继器:中继器1和中继器2(在标签内)
对于上面,我编写了以下代码:
DataSet ds = new DataSet();
ds = cls.ReturnDataSet("sp_data",
new SqlParameter("@From_Time", "2014-11-01 00:00:00.000"),
new SqlParameter("@To_Time", "2014-11-03 00:00:00.000"));
repeater1 .DataSource = ds.Tables[0];
repeater1 .DataBind();
这将绑定中继器1。
对于 Repeater2,我编写了以下代码:
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
DataSet ds = new DataSet();
ds = cls.ReturnDataSet("sp_data",
new SqlParameter("@From_Time", "2014-11-01 00:00:00.000"),
new SqlParameter("@To_Time", "2014-11-03 00:00:00.000"));
Repeater rpt = (Repeater)e.Item.FindControl("Repeater2");
rpt.DataSource = ds.Tables[1];
rpt.DataBind();
}
}
现在整个输出是这样的:
Id Ssdvalue stptime
1 112 3 hours 4hours 5 hours 6 hours 12minutes 20minutes
2 234 3 hours 4hours 5 hours 6 hours 12minutes 20minutes
3 450 3 hours 4hours 5 hours 6 hours 12minutes 20minutes
4 987 3 hours 4hours 5 hours 6 hours 12minutes 20minutes
5 456 3 hours 4hours 5 hours 6 hours 12minutes 20minutes
6 091 3 hours 4hours 5 hours 6 hours 12minutes 20minutes
但是上面的输出是不正确的。
I want output like Below:
Id Ssdvalue stptime
1 112 3 hours
2 234 4hours
3 450 5 hours
4 987 6 hours
5 456 12minutes
6 091 20minutes
那么如何获得上述输出呢?
这样做:-
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item ||
e.Item.ItemType == ListItemType.AlternatingItem)
{
DataSet ds = new DataSet();
ds = cls.ReturnDataSet("sp_data",
new SqlParameter("@From_Time", "2014-11-01 00:00:00.000"),
new SqlParameter("@To_Time", "2014-11-03 00:00:00.000"));
Label Label1 = (Label)e.Item.FindControl("Label1");
Repeater rpt = (Repeater)e.Item.FindControl("Repeater2");
var source = ds.Tables[1].AsEnumerable()
.Where(x => x.Field<int>("Id") == Convert.ToInt32(Label1.Text))
.Select(x => new
{
stptime= x.Field<DateTime>("stptime")
});
rpt.DataSource = source ;
rpt.DataBind();
}
}
由于您需要使用相同的 ID 进行映射,因此您必须根据 Id 过滤数据,即 Id
1 将映射到 stpTime
3 小时,依此类推。因此,我们需要过滤我正在使用 LINQ Where
子句执行的主要数据源,并且我们正在从 Label
获取相应的 Id。