Link to home
Start Free TrialLog in
Avatar of oldmuttonhead
oldmuttonheadFlag for United States of America

asked on

Selecting multiple dates for a database

I have a web application that is designed in asp.  I am in the process of rebuilding it using Visual Studio 2008 and asp.NET.  I am transitioning to my pathetic attempt at security and authentication to the .NET membership model.  While I'm rebuilding this from the ground up, I'm taking another look at the UI and there's one thing that has always been poorly done, but I do not have any ideas for how to make it better.  

The application is a website for sports officials.  I have a SQL Server 2000 database with 5 tables:

Officials - RefID, FirstName, LastName, Address, City, State, Zip, HPhone, WPhone, CPhone, email, username, password  (The username and password fields will be going away as I am implementing the .NET membership.)

Dates - DateID, DateData (DateID is just a int, DataData is datetime field)

Sports - SportID, Sport

OffSports - RefID, Sport ID, Exp

OffDates - RefID, DateID

Currently, an officials logs in to the database, clicks "Edit my Information", then clicks "Add/Edit Dates".  The official chooses a date from drop down lists for month, day and year, or can click on a small pop-up calendar and it fills those lists in for you.  Then click "Add" and the page is refreshed while the date is added.  A perfectly good solution if you are adding one date to your list of dates.  However, if you are adding multiple dates, it's a pain.  It takes forever if you start adding 10, 20, or more dates at once as you wait for the page to reload after each date is added.  It would be much easier if I could have some sort of a calendar control to make this work.  If it takes changing the way the database is structured, that's fine.  I'd like it to have a calendar with the dates that are already closed are bold or highlighted or otherwise formatted to indicate that (even a checkbox would be ok) and then if you click on a date it either toggles it on or off.  

Any ideas to point me in the right direction to achieve this?  

Thanks in advance!
ASKER CERTIFIED SOLUTION
Avatar of PierreBeukes
PierreBeukes

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of oldmuttonhead

ASKER

Thanks for pointing me in the right direction