Click here to Skip to main content
15,882,315 members
Articles / Web Development / ASP.NET

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

Rate me:
Please Sign up or sign in to vote.
1.33/5 (3 votes)
27 Nov 20071 min read 35.8K   378   15   1
Creating Business Calendar for using ASP.Net with C#, SQL Server & Javascript


I wish this calendar will help developers those who are working in ASP.NET using Calendar Control (server control) and JavaScript.

This calendar contains some additional functions (four buttons). These functions can be used to scroll year/month to either the future or the past. Further this will display the selected month name in the label control.

Screenshot - 1.jpg

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.

Screenshot - 2.jpg

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).

Screenshot - 3.jpg

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).

Screenshot - 4.jpg

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.


Srinivasan Venkatachalam


This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Written By
Web Developer
India India
Hi i am srinivasam venkatachalam. At present i am working as a Senior Software Engineer in .Net Technologies.

Comments and Discussions

GeneralSuggestion Pin
saini arun14-Mar-10 1:00
saini arun14-Mar-10 1:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.