[TooMuchViagra]

Hi,

I'm using a calendar control in my page to allow clients to pick a date and schedule an appointment. I have a simple database for now that consists of two tables: Clients and Appointments and I'm using Linq to Entities.

I want to disable the date in the calendar where there are 5 appointments scheduled for already so that clients can't select it. I know how to manipulate the calendar with the day_render event and how to disable hardcoded dates, What I'm having problem with is how to approach and implement this requirement.

Another table in the db?(I'm really bad at db design) Linq Count function?

Basically I'm looking for suggestions, tips, code help c# or vb.

Thanks

[Nakor]

you already have a table storing the appointments, you should just need to get a count of the current/active appointments for the client. I can't see where you would need another database table unless I'm just not understanding something

[TooMuchViagra]

Nakor, on 11 December 2012 - 05:30 PM, said:

you already have a table storing the appointments, you should just need to get a count of the current/active appointments for the client. I can't see where you would need another database table unless I'm just not understanding something

I figured it out. Count function did the trick.
thank you