i want to write a code in c# or Vb that can help split the result of my sql query using date just like below

 <asp:Repeater runat="server" ID="repeaterlistasset">
 <HeaderTemplate >

 
 
<table class="table table-bordered multiple_table AuditByDateGrid_Parent " id="exporttable" border="1">
 
 
 <tr>
 <th class="warning ">Asset Tag ID</th>
 <th class="warning ">Description</th>
 <th class="warning center">Original Site</th>
 <th class="warning center">Original Location</th>
 <th class="warning ">Audited to Site</th>
 <th class="warning ">Audited to Location</th>
 <th class="warning right">Last Audit Date</th>
 <th class="warning right">Audit By</th>
 </tr>
 </HeaderTemplate>
 <ItemTemplate>
 
 
 <tr class="">
 <td><%# Eval("Asset_Tag_ID")%></td>
 <td><%# Eval("Description")%></td>
 <td class="center"><%# Eval("Site")%></td>
 <td><%# Eval("Location")%></td>


 <td><%# Eval("audit_site")%></td>
 <td><%# Eval("audit_location")%></td>
 <td class="center"><%# Eval("audit_date")%></td>
 <td><%# Eval("audit_by")%></td>
 </tr>
 </ItemTemplate>
 <FooterTemplate >

 
 <tr class="price_total" runat="server" id="tr_total" visible="false" >
 <td style="text-align:left; font-weight:bold" colspan="8"><span runat="server" id="spn_total_num"></span> Assets</td>
 </tr>
 
 
 
</table>
 </FooterTemplate> 
 </asp:Repeater> 

My Back end code is

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Using cmdd5 As New SqlCommand()
            cmdd5.CommandText = "select Asset_Tag_ID,Description,Site,Location,audit_site,audit_location,audit_date,audit_by,audit_name from [auditing] as aud1 JOIN add_asset ON (add_asset.id=aud1.asset_primary_id) Group  By audit_name,Asset_Tag_ID,Description,Site,Location,audit_site,audit_location,audit_date,audit_by"



            cmdd5.Connection = con
            con.Open()
            repeaterlistasset.DataSource = cmdd5.ExecuteReader()
            repeaterlistasset.DataBind()

            con.Close()
        End Using

Here is a screen shot of my expected result