Render Calendar Control Based on Database Table

Question

Hi All,

I'm sure you're over when people say they are new to C#, but I am, so I need any answers to be fairly detailed.

Currently I'm building an application that records appointments for doctors.  On the screen there is a calendar control (calDate) used to navigate to a day's appointments.  I want the dates on the calendar control to be rendered in a different colour if the selected doctor has appointments makred as available in the database table.

I have no idea how to create a data source or whatever is required for a calender control to read and then how to render the calender accordingly.

I hope I've explained myself properly, but thank you in advance for your assistance.

Eloise