creating yearly calendar in C# by storing it in sql table

Question

i have medical database with some tables one of these tables is calendar table it has the fielsd as:

date     
day name 
day no of the week 
flag          // this flag indecate if this date is friday or holiday 

the user enter the year to create the 12 months   OR enter the month to create only the entred month 

 

any idea 

thanks 

O. Abuzaid 

 

how can i create calendar progrmmicly in c#