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="repeater1">
<ItemTemplate>
<table class="table table-bordered multiple_table AssetTagReportGrid_Parent" id="reportGrid">
<tbody>
<tr class="heading ">
<td colspan="5">Due Date: <b>12/11/2019</b></td>
</tr>
<tr>
<th class="warning ">Asset Tag ID</th>
<th class="warning ">Description</th>
<th class="warning ">Check-out Date</th>
<th class="warning ">Due Date</th>
<th class="warning ">Assigned to</th>
</tr>
<tr class="">
<td>12323</td>
<td>hp laptop</td>
<td>11/21/2019</td>
<td>12/11/2019</td>
<td>Uchenna Franklin Nwanegbo</td>
</tr>
<tr class="heading ">
<td colspan="5">
Due Date: <b>12/05/2019</b>
</td>
</tr>
<tr>
<th class="warning ">Asset Tag ID</th>
<th class="warning ">Description</th>
<th class="warning ">Check-out Date</th>
<th class="warning ">Due Date</th>
<th class="warning ">Assigned to</th>
</tr>
<tr class="">
<td>223</td>
<td>hp laptop</td>
<td>11/12/2019</td>
<td>12/05/2019</td>
<td>Uchenna Franklin Nwanegbo</td>
</tr>
<tr class="">
<td>12345</td>
<td>laptop</td>
<td>11/12/2019</td>
<td>12/05/2019</td>
<td>Uchenna Franklin Nwanegbo</td>
</tr>
<tr class="">
<td>123467</td>
<td>hp laptop</td>
<td>11/12/2019</td>
<td>12/05/2019</td>
<td>Uchenna Franklin Nwanegbo</td>
</tr>
<tr class="price_total">
<td style="text-align:left; font-weight:bold">4 Assets</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</tbody>
</table>
</ItemTemplate>
</asp:Repeater>
con.open
Using cond5 As New SqlConnection(strConnString)
Using cmdd5 As New SqlCommand()
cmdd5.CommandText = "SELECT * FROM add_asset WHERE Asset_Name LIKE '%'+'" & txtsearchassets.Value & "' + '%' ORDER BY Asset_Name ASC "
cmdd5.Connection = cond5
cond5.Open()
repeaterlistasset.DataSource = cmdd5.ExecuteReader()
repeaterlistasset.DataBind()
cond5.Close()
End Using
End Using
con.close
