Business Calendar Using ASP.Net with C#, SQL Server & Javascript

This calendar displays working days only (Except Holidays and week ends). So user can select only working days. Week ends are automatically restricted for users.

This calendar will display the current date in red square box and holiday will be displayed with <place w:st="on">Orange shade (Only for display purpose).

So user can select any working day from this calendar, once user selects a date the calendar will get closed and the selected date will be assign to parent form Date control (Text box).

Using the code

//Create separate class public method for fetching holidays from holiday master table.

// Class Object Name: objBusiness

// Method Name: GetBusinessHolidays();

DataSet ds = objBusiness.GetBusinessHolidays();

SQL Script :

Use this sql script in your stored procedure or query for fetching holiday's from holiday master table

SELECT Replace(CONVERT(varchar , holiday_date,106),' ' ,'-') AS Holidat_Date

FROM tblHoliday_Master Order by holiday_date.

Whether u need anyother information pls let me know ur problem what did u face.

Thanks

Srinivasan Venkatachalam

rvsrinivasan@gmail.com