Question

asp.net如何绑定repeater里面的ItemTemplate

asp.net后台绑定repeater里面的ItemTemplate <td><字段值></td>

。
数据库的选项不是固定的abcd4个 可能有多个。，
怎么动态的在asp.net后台绑定repeater里面的ItemTemplate <td><以及字段值></td>。
上代码、可以加分

Answer 1

可以用ItemDataBound事件来写数据绑定
前台页面：
<asp:Repeater ID="Repeater1" runat="server" onitemdatabound="Repeater1_ItemDataBound">
<HeaderTemplate>
//这里列头我就省略了

</HeaderTemplate>
<ItemTemplate>
<asp:Literal ID="item" runat="server"></asp:Literal>
</ItemTemplate>

</asp:Repeater>
.cs文件中：
protected void Page_Load(object sender, EventArgs e)
{
Repeater1.DataSource = GetData();
Repeater1.DataBind();
}
private string[] GetMonth()
{
DateTime startTime = new DateTime(DateTime.Now.Year, 1, 1);
DateTime endTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);

List<string> lisMonth = new List<string>();
for (DateTime dt = startTime; dt <= endTime; dt = dt.AddMonths(1))
{
lisMonth.Add(dt.ToString("yyyy-MM"));
}

return lisMonth.ToArray();
}

private DataTable GetData()
{
string[] arrMonth = GetMonth();
string[] arrCor = new string[arrMonth.Length + 1];
arrCor[0] = "FACTORY";
for (int i = 0; i < arrMonth.Length; i++)
{
arrCor[i + 1] = "MONTH" + i;
}
DataTable dtSource = new DataTable();
for (int i = 0; i < arrCor.Length; i++)
{
dtSource.Columns.Add(arrCor[i]);
}

DataRow drNew;

for (int i = 0; i < 13; i++)
{
drNew = dtSource.NewRow();
drNew["FACTORY"] = "工厂" + (i + 1);

for (int j = 0; j < arrMonth.Length; j++)
{
drNew["MONTH" + j] = Convert.ToDateTime(arrMonth[j]).AddYears(-i).ToString("yyyy-MM");
}

dtSource.Rows.Add(drNew);
}

return dtSource;
}
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
DataRowView drv = e.Item.DataItem as DataRowView;
StringBuilder sb = new StringBuilder();
string[] arrMonth = GetMonth();

sb.Append("<tr style=\"background-color:White\">");
sb.Append("<td align=\"center\">" + drv["FACTORY"] + "</td>");
for (int i = 0; i < arrMonth.Length; i++)
{
sb.Append("<td align=\"center\">" + drv["MONTH" + i] + "</td>");
}

sb.Append("</tr>");

Literal lit = e.Item.FindControl("item") as Literal;
lit.Text = sb.ToString();
}
}
你可以试着这样写一下，看看能否达到你要的效果，前一段时间我也是要展示这种列不固定的效果，就是这样实现的。

Answer 2

搜下repeater嵌套，外面绑定题干，里面repeater绑定选项。选项sql你搜下行转列