Loop for each day in the current month and check rows for a match
How can I write a loop to run for each day in the current month and then check to see if the Dataset has a record that matches one of those days and take an action?

    For Day As Integer = 1 To DaysInTheMonth
            For Each row In MyRows
                If row.Date.Day = Day Then
                    ' Yup! Found Data for this day!
                    ' Add Data to string
                Else
                    ' No Data To Display
                    ' Add Blank Field String
                End If
            Next
    Next

This generates too many rows in the table I have it building. Basically, every day gets as many rows as there are that contain data.

I need this to be able to tell if there is data for this day or not and if not to set values to 0.
Loop for each day in the current month and check rows for a match
===

How can I write a loop to run for each day in the current month and then check to see if the Dataset has a record that matches one of those days and take an action?

    For Day As Integer = 1 To DaysInTheMonth
            For Each row In MyRows
                If row.Date.Day = Day Then
                    ' Yup! Found Data for this day!
                    ' Add Data to string
                Else
                    ' No Data To Display
                    ' Add Blank Field String
                End If
            Next
    Next

This generates too many rows in the table I have it building. Basically, every day gets as many rows as there are that contain data.

I need this to be able to tell if there is data for this day or not and if not to set values to 0.