62,074
社区成员
发帖
与我相关
我的任务
分享
SELECT name, data
FROM dbo.Table_5
GROUP BY name, data
<table border="1">
<asp:Repeater ID="Repeater1" runat="server" OnItemDataBound="Repeater1_ItemDataBound">
<ItemTemplate>
<tr>
<td>
<%#Eval("name") %>
<asp:HiddenField ID="hf1" Value='<%#Eval("name") %>' runat="server" />
</td>
<asp:Repeater ID="Repeater2" runat="server">
<ItemTemplate>
<td>
<%#Eval("data") %>
</td>
</ItemTemplate>
</asp:Repeater>
</tr>
</ItemTemplate>
</asp:Repeater>
</table>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Repeater1.DataSource = TM.DBUtility.DbHelperSQL.GetDataSet("select name from View_1 group by name");
Repeater1.DataBind();
}
}
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
HiddenField hf = (HiddenField)e.Item.FindControl("hf1");
Repeater rpt2 = (Repeater)e.Item.FindControl("Repeater2");
rpt2.DataSource = TM.DBUtility.DbHelperSQL.GetDataSet(string.Format("select * from View_1 where name='{0}'", hf.Value));
rpt2.DataBind();
}