c# - 如何按列分隔DataTable并存储以备后用

Question

DataTable(已经按Ee排序):

Title           EventDate                   EndDate 
Testing 1       3/23/2016 11:00:00 AM       3/23/2016 12:00:00 PM
Testing 2       3/23/2016 5:00:00 PM        3/23/2016 6:00:00 PM
Testing 9       3/24/2016 4:00:00 PM        3/24/2016 5:00:00 PM
Testing 5       3/29/2016 11:00:00 AM       3/29/2016 12:00:00 PM
Testing 6       3/29/2016 11:00:00 AM       3/29/2016 12:00:00 PM
Testing 4       3/29/2016 1:00:00 PM        3/29/2016 2:00:00 PM

ASP.net 标签:

<asp:Label ID="lDates" runat="server"></asp:Label>

我如何编写代码以便数据表像这样显示在标签中(可能不是这样，但我可以通过某种方式将它们按日期分隔并显示在不同的地方):

3/23:   Testing 1
        Testing 2

3/24:   Testing 9

3/29:   Testing 5
        Testing 6
        Testing 4

Answer 1

我通过遍历 DataTable 来做到这一点，获取当前的 EventDate 并与之前的进行核对。

这是 vb.net 代码:

    'get first date from table in format day.month - adapt to Your date format    
    Dim pDT As String = String.Format("{0:dd.MM}", dt.Rows(0)("EventDate"))
    Dim res As String = "<table cellspacing=0 cellpadding=0><tr><td style='text-align:left;vertical-align:top;border-bottom:solid 1px gray;'>" + pDT + "</td><td style='text-align:left;vertical-align:top;padding-bottom:10px;border-bottom:solid 1px gray;padding-left:10px;'>" + dt.Rows(0)("Title") + "<br>"
For x = 1 To dt.Rows.Count - 1
   'get EventDate from current row
   Dim nD As String = String.Format("{0:dd.MM}", dt.Rows(x)("EventDate"))
   If nD <> pDT Then
      res += "<td></tr>"
      pDT = String.Format("{0:dd.MM}", dt.Rows(x)("EventDate"))
      res += "<tr><td style='text-align:left;vertical-align:top;border-bottom:solid 1px gray;'>" + pDT + "</td><td style='text-align:left;vertical-align:top;padding-bottom:10px;border-bottom:solid 1px gray;padding-left:10px;'>" + dt.Rows(x)("Title") + "<br>"
   Else
      res += dt.Rows(x)("Title") + "<br>"
   End If
Next
res += "</td></tr></table>"
lDates.Text = res

由于我不使用c#，下面的代码是由在线转换器转换的(我希望它是正确的转换:( ):

string pDT = string.Format("{0:dd.MM}", dt.Rows[0]["EventDate"]);
                string res = "<table cellspacing=0 cellpadding=0><tr><td style='text-align:left;vertical-align:top;border-bottom:solid 1px gray;'>" + pDT + "</td><td style='text-align:left;vertical-align:top;padding-bottom:10px;border-bottom:solid 1px gray;padding-left:10px;'>" + dt.Rows[0]["Title"] + "<br>";
                for (int x = 1; x <= dt.Rows.Count - 1; x++)
                {
                    string nD = string.Format("{0:dd.MM}", dt.Rows[x]["EventDate"]);
                    if (nD != pDT)
                    {
                        res += "<td></tr>";
                        pDT = string.Format("{0:dd.MM}", dt.Rows[(x]["EventDate"]);
                        res += "<tr><td style='text-align:left;vertical-align:top;border-bottom:solid 1px gray;'>" + pDT + "</td><td style='text-align:left;vertical-align:top;padding-bottom:10px;border-bottom:solid 1px gray;padding-left:10px;'>" + dt.Rows[x]["Title"] + "<br>";
                    }
                    else
                    {
                        res += dt.Rows[x]["Title"] + "<br>";
                    }
                }
                res += "</td></tr></table>";
                lDates.Text = res;

这是一些脏代码。

更新(填充Repeater):

然后您必须创建新的空DataTable 并使用几乎相同的代码，但是，将值放入string 中，将它们分别放入新的DataTable(有 2 列，一列用于日期，另一列用于标题):

代码隐藏(vb.net):

Dim newDT As New DataTable
            newDT.Columns.Add("Date", GetType(String))
            newDT.Columns.Add("Titles", GetType(String))
            Dim pDT = String.Format("{0:dd.MM}", dt.Rows(0)("EventDate"))
            Dim titles As String = dt.Rows(0)("Title") + ","
            For x = 1 To dt.Rows.Count - 1
                Dim nD = String.Format("{0:dd.MM}", dt.Rows(x)("EventDate"))
                If pDT <> nD Then
                    titles = Mid(titles, 1, Len(titles) - 1)
                    newDT.Rows.Add({pDT, String.Join("<br>", titles.Split(",").ToArray)})
                    pDT = String.Format("{0:dd.MM}", dt.Rows(x)("EventDate"))
                    titles = dt.Rows(x)("Title") + ","
                Else
                    titles += dt.Rows(x)("Title") + ","
                End If
            Next
            titles = Mid(titles, 1, Len(titles) - 1)
            newDT.Rows.Add({pDT, String.Join("<br>", titles.Split(",").ToArray)})
            rptDate.DataSource = newDT
            rptDate.DataBind()

codebehind (c#)(p.s. 我不确定它是否正确转换。再次抱歉，我对 c# 非常非常弱:( ):

DataTable newDT = new DataTable();
newDT.Columns.Add("Date", typeof(string));
newDT.Columns.Add("Titles", typeof(string));
string pDT = string.Format("{0:dd.MM}", dt.Rows[0]["EventDate"]);
string titles = dt.Rows[0]("Title") + ",";
for (x = 1; x <= dt.Rows.Count - 1; x++) {
    string nD = string.Format("{0:dd.MM}", dt.Rows[0]["EventDate"]);
    if (pDT != nD) {
        titles = Strings.Mid(titles, 1, Strings.Len(titles) - 1);
        newDT.Rows.Add({
            pDT,
            string.Join("<br>", titles.Split(",").ToArray)
        });
        pDT = string.Format("{0:dd.MM}", dt.Rows[x]("EventDate"));
        titles = dt.Rows[x]("Title") + ",";
    } else {
        titles += dt.Rows[x]("Title") + ",";
    }
}
titles = Strings.Mid(titles, 1, Strings.Len(titles) - 1);
newDT.Rows.Add({
    pDT,
    string.Join("<br>", titles.Split(",").ToArray)
});
rptDate.DataSource = newDT;
rptDate.DataBind();

aspx:

<asp:Repeater runat="server" ID="rptDate">
            <HeaderTemplate>
                <table cellpadding="0" cellspacing="0">
            </HeaderTemplate>
            <ItemTemplate>
                <tr>
                    <td class="td1">
                        <%# Container.DataItem("Date")%>
                    </td>
                    <td class="td2">
                        <%# Container.DataItem("Titles")%>
                    </td>
                </tr>
            </ItemTemplate>
            <FooterTemplate>
                </table>
            </FooterTemplate>
        </asp:Repeater>

样式:

.td1, .td2 {width:250px; border-bottom:solid 1px gray; text-align:left; vertical-align:top;}
.td1 {font-weight:bold;}
.td2 {font-style:italic;}