Databases
StackOverflow2013
Postsdbo
PODisplaying records grouped by month and year in asp.net
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODisplaying records grouped by month and year in asp.net
    primarykey
    data
    text
    <p>I need to sort my records by date (month &amp; year) as displayed on my asp.net page;<br> Any ideas / suggestions would be helpful. </p> <p>This is the code I currently have</p> <pre><code> &lt;table width="40%" border="0" style="margin-left:auto; margin-right:auto;"&gt; &lt;tr&gt;&lt;td&gt;&lt;asp:Label ID="lblGridHeader" CssClass="TextFont" Text="" runat="server"&gt;&lt;/asp:Label&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt; &lt;td align="center"&gt; &lt;asp:GridView ID="gvInvoiceList" runat="server" AutoGenerateColumns="false" AllowSorting="true"&gt; &lt;columns&gt; &lt;asp:TemplateField ItemStyle-Width="10%" HeaderText="File Type"&gt; &lt;ItemTemplate&gt;&lt;asp:HyperLink ID="imgFileType" ImageUrl="images/Icon_Pdf.gif" NavigateUrl='&lt;%# SetNavigateUrl(Eval("Name")) %&gt;' runat="server"&gt;&lt;/asp:HyperLink&gt;&lt;/ItemTemplate&gt; &lt;/asp:TemplateField&gt; &lt;asp:boundfield datafield="Name" headertext="Invoice #"/&gt; &lt;asp:boundfield datafield="LastWriteTime" headertext="Date Modified"/&gt; &lt;/columns&gt; &lt;/asp:GridView&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; </code></pre> <p><strong>Code behind:</strong> </p> <pre><code> If files.Count &gt; 0 Then Dim DT As New DataTable() DT.Columns.Add(New DataColumn("Name", System.Type.GetType("System.String"))) DT.Columns.Add(New DataColumn("LastWriteTime", System.Type.GetType("System.String"))) Dim strCurrentMonth As String = "" For Each f As FileInfo In files If (MonthName(f.LastWriteTime.Month) &lt;&gt; strCurrentMonth) And (strCurrentMonth &lt;&gt; "") Then gvInvoiceList.DataSource = DT gvInvoiceList.DataBind() lblGridHeader.Text = MonthName(f.LastWriteTime.Month) &amp; " - " &amp; Year(f.LastWriteTime) Else lblGridHeader.Text = MonthName(f.LastWriteTime.Month) &amp; " - " &amp; Year(f.LastWriteTime) End If Dim Row1 As DataRow Row1 = DT.NewRow() Row1("Name") = f.Name Row1("LastWriteTime") = f.LastWriteTime DT.Rows.Add(Row1) strCurrentMonth = MonthName(f.LastWriteTime.Month) Next gvInvoiceList.DataSource = DT gvInvoiceList.DataBind() Else lblSummary.Text = "No data to show." End If </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USDotNetRookie
    1. USDotNetRookie
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODisplaying records grouped by month and year in asp.net
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PODisplaying records grouped by month and year in asp.net
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PODisplaying records grouped by month and year in asp.net
      1. USTroy
      1. VTFavorite
    1. COInclude some details about how the records are grouped. It's tough to visualize what you need without knowing what the data looks like.
      singulars
      1. PODisplaying records grouped by month and year in asp.net
      1. USJames Johnson
    2. COI don't understand why you need a loop. If the database is doing the grouping for you, can't you just display the results of the query?
      singulars
      1. PODisplaying records grouped by month and year in asp.net
      1. USBill
    3. COI need to display them in seperate blocks with a header of "Month Year"
      singulars
      1. PODisplaying records grouped by month and year in asp.net
      1. USDotNetRookie
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload