Hi.
I have 2 datetime pickers, start and end dates

dates will be shown when a user selects a month.

now, when they change the month, I will be getting some datetime values from SQL, depending on the month they choose (or rather for each month they select)

now, these dates from SQL are start and end dates.

What I want is, to disable dates which are stored/returned back to me from SQL, kind of like a booking system.

how can I do this?


so say if in SQL we have this:


dates (2 fields)

16/07/2006 -> 21/07/2006
22/07/2006 -> 13/08/2006



I want the date ranges of these to be disabled in the DTP control when they select the months

is this possible? how?

Thanks!