ASP.NET

objConnection.OpenConnection()
        'sql = "Select * From brewerLate Where month = 10"
        sql = "Select * From brewerLate Where (month) = '" & intCurMonth & "'"
        da = New SqlDataAdapter(sql, objConnection.cnn)
        da.Fill(ds, "brewerLate")

        sql = "Select * From portlandLate Where (month) = '" & intCurMonth & "'"
        da = New SqlDataAdapter(sql, objConnection.cnn)
        da.Fill(ds, "portlandLate")
        objConnection.CloseConnection()

        'Dim brewer As String = "October 01,October 15,October 29"
        brewer = ds.Tables("brewerLate").Rows(0).Item(1)
        days = brewer.Split(","c)

        For Each strDay In days
            If e.Day.Date = strDay Then
                e.Cell.Controls.Add(New LiteralControl("<p>Brewer Working!</p>"))
                e.Cell.BorderColor = Drawing.Color.Black
                e.Cell.BorderWidth = 1
                e.Cell.BorderStyle = BorderStyle.Solid
                e.Cell.BackColor = Drawing.Color.LightCyan
            End If
        Next