[RESOLVED] Read date from database to monthcalendar

[Radjesh Klauke]

Ola,

Now I've hardcoded my date into my app, but now I want to read it from the database. I knowhow to read the columns, but unfortunately I don't now how to make the date appear into the monthcalendar.

Select Case MyDGV.SelectedCells(8).Value.ToString()
    Case "Radjesh"
        With MyMonthCal
            .MarkedDates = New System.DateTime() {New System.DateTime(2010, 3, 3), New System.DateTime(2010, 3, 10), New System.DateTime(2010, 3, 17), New System.DateTime(2010, 3, 24), New System.DateTime(2010, 3, 31), _
            New System.DateTime(2010, 4, 7), New System.DateTime(2010, 4, 14), New System.DateTime(2010, 4, 21), New System.DateTime(2010, 4, 28), _
            New System.DateTime(2010, 5, 12), New System.DateTime(2010, 5, 19), New System.DateTime(2010, 5, 26)}
MyNotes.Text = "blablablabla"
        .UpdateMarkedDates()
    Case  "VB.NET"
        'etc...

Let me start by asking what the best way would be to setup the table?

Thanks for the help in advance.