Click here to Skip to main content
12,242,492 members (62,991 online)
Click here to Skip to main content
Add your own
alternative version

Stats

25.7K views
342 downloads
14 bookmarked
Posted

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

, 27 Nov 2007
Rate this:
Please Sign up or sign in to vote.
Creating Business Calendar for using ASP.Net with C#, SQL Server & Javascript

Introduction

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

Thanks

Srinivasan Venkatachalam

rvsrinivasan@gmail.com

License

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

Share

About the Author

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


You may also be interested in...

Comments and Discussions

 
GeneralSuggestion Pin
arun$aini14-Mar-10 2:00
memberarun$aini14-Mar-10 2: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.

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.160426.1 | Last Updated 27 Nov 2007
Article Copyright 2007 by Srinivasan Venkatachalam
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid