asp.net中继动态合并列(asp.net repeater merge columns dyna

我在我的ASP.net页的中继器。我想合并具有相同的文本列。当我绑定的DataTable这应该动态地发生。我寻觅了很多关于这一点。但是，没有成功。我怀疑是否有可能与中继器。我也想提一提，也有图像按钮和复选框每排。

这是我的中继来源： -

<asp:Repeater ID="rpt1" runat="server" onitemcommand="rpt1_ItemCommand">
        <HeaderTemplate>
            <table border="1" cellpadding="10" width="50%">
            <tr>
                <th>Item Name</th>
                <th>As On</th>
                <th>Price</th>
                <th></th>
                <th></th>
            </tr>
        </HeaderTemplate>
        <ItemTemplate>

            <tr>
                <td>
                    <asp:Label ID="lblRelayName" runat="server" Text='<%# Eval("ItemName") %>'></asp:Label>
                </td>
                <td>
                    <asp:Label ID="lblTimeFrom" runat="server" Text='<%# Eval("Date") %>'></asp:Label>
                </td>
                <td>
                    <asp:Label ID="lblPrice" runat="server" Text='<%# Eval("Price") %>'></asp:Label>
                </td>
                <td>
                    <asp:ImageButton ID="imgBtnStatus" runat="server" 
                        ImageUrl="~/img/btnGet.jpg" 
                        CommandName="Change"  style="width: 36px; border-width: 0px; margin-top: -4px; vertical-align: middle;" />
                </td>
                <td>
                    <asp:CheckBox ID="chkStatus" runat="server" Checked="true" />
                </td>
            </tr>

        </ItemTemplate>
        <FooterTemplate>
            </table>
        </FooterTemplate>

        </asp:Repeater>

这是我如何填写中继器： -

protected void Page_Load(object sender, EventArgs e)
{
    rpt1.DataSource = GetData();
    rpt1.DataBind();
}

private DataTable GetData()
{
    DataTable dt = new DataTable();
    dt.Columns.Add("ItemName");
    dt.Columns.Add("Date");
    dt.Columns.Add("Price");

    DataRow dr = dt.NewRow();
    dr["ItemName"] = "Orange";
    dr["Date"] = "01/01/2015";
    dr["Price"] = "50";
    dt.Rows.Add(dr);

    dr = dt.NewRow();
    dr["ItemName"] = "Orange";
    dr["Date"] = "02/01/2015";
    dr["Price"] = "51";
    dt.Rows.Add(dr);

    dr = dt.NewRow();
    dr["ItemName"] = "Orange";
    dr["Date"] = "03/01/2015";
    dr["Price"] = "55";
    dt.Rows.Add(dr);

    dr = dt.NewRow();
    dr["ItemName"] = "Apple";
    dr["Date"] = "01/01/2015";
    dr["Price"] = "95";
    dt.Rows.Add(dr);

    dr = dt.NewRow();
    dr["ItemName"] = "Apple";
    dr["Date"] = "03/01/2015";
    dr["Price"] = "98";
    dt.Rows.Add(dr);

    dr = dt.NewRow();
    dr["ItemName"] = "Banana";
    dr["Date"] = "01/01/2015";
    dr["Price"] = "48";
    dt.Rows.Add(dr);

    return dt;
}

好吧，我能得到它看起来像这样。我认为这是你想要的东西：

但是，我不得不作出显著改变你的代码，使这项工作。首先，数据表和DataRow是相当过时的课程......他们不支持LINQ的，等等。所以我切换到只是使用普通的对象。其次，你将需要做的合并在你的代码隐藏。它仍然在你不会有更改即将从服务器返回的原始数据意义上的“动态的”。但你必须“过程”绑定到Repeater控件之前的数据。这是我结束了：

.ASPX：

<asp:Repeater ID="rpt1" runat="server">
    <HeaderTemplate>
        <table border="1" cellpadding="10" width="50%">
            <tr>
                <th>Item Name</th>
                <th>As On</th>
                <th>Price</th>
                <th></th>
                <th></th>
            </tr>
    </HeaderTemplate>
    <ItemTemplate>
        <tr>
            <td style='vertical-align: top; display: <%# ((bool) Eval("IsFirstRowWithThisItemName")) ? "" : "none" %>;' 
                rowspan="<%# Eval("CountOfProductsWithThisItemName") %>">
                <asp:Label ID="lblRelayName" runat="server" Text='<%# Eval("ItemName") %>'></asp:Label>
            </td>
            <td>
                <asp:Label ID="lblTimeFrom" runat="server" Text='<%# Eval("ShortDate") %>'></asp:Label>
            </td>
            <td>
                <asp:Label ID="lblPrice" runat="server" Text='<%# Eval("PriceDisplay") %>'></asp:Label>
            </td>
            <td>
                <asp:ImageButton ID="imgBtnStatus" runat="server"
                    ImageUrl="~/img/btnGet.jpg"
                    CommandName="Change" Style="width: 36px; border-width: 0px; margin-top: -4px; vertical-align: middle;" />
            </td>
            <td>
                <asp:CheckBox ID="chkStatus" runat="server" Checked="true" />
            </td>
        </tr>
    </ItemTemplate>
    <FooterTemplate>
        </table>
    </FooterTemplate>
</asp:Repeater>

.ASPX.CS

public partial class About : Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        rpt1.DataSource = this.GetMergedData(this.GetData());
        rpt1.DataBind();

    }

    private List<Product> GetMergedData(List<Product> allProducts)
    {
        List<Product> mergedProducts = new List<Product>();

        var groupingsByName =
            allProducts
            .GroupBy(product => product.ItemName);

        foreach (var groupingByName in groupingsByName)
        {
            Product firstProduct = groupingByName.First();
            firstProduct.CountOfProductsWithThisItemName = groupingByName.Count();
            firstProduct.IsFirstRowWithThisItemName = true;
            mergedProducts.Add(firstProduct);

            mergedProducts.AddRange(groupingByName.Skip(1));
        }

        return mergedProducts;
    }

    private List<Product> GetData()
    {
        return new List<Product>()
        {
            new Product("Orange", DateTime.Parse("01/01/2015"), 50),
            new Product("Orange", DateTime.Parse("02/01/2015"), 51),
            new Product("Orange", DateTime.Parse("03/01/2015"), 55),
            new Product("Apple", DateTime.Parse("01/01/2015"), 95),
            new Product("Apple", DateTime.Parse("03/01/2015"), 98),
            new Product("Banana", DateTime.Parse("01/01/2015"), 48),
        };
    }
}

public class Product
{
    public string ItemName { get; set; }
    public DateTime Date { get; set; }
    public decimal Price { get; set; }
    public string ShortDate { get { return this.Date.ToShortDateString();  } }
    public string PriceDisplay { get { return this.Price.ToString("C");  } }

    public int CountOfProductsWithThisItemName { get; set; }
    public bool IsFirstRowWithThisItemName { get; set; }

    public Product(string itemName, DateTime date, decimal price)
    {
        this.ItemName = itemName;
        this.Date = date;
        this.Price = price;
    }
}