How to use dropdownlist control to show date?

Question

0.00/5 (No votes)

See more:

I have an appointment management system for Salon I have to show dates in dropdownlist from today to next 60 days And I have to show times from 09:00 Am to 09:30 PM with the interval of 30 mins When the user logs in the user can only see dates which are available for the appointment. When the user selects the available date from the first dropdownlist then in the time dropdownlist he should only see the time or the time slots which are available to book the appointment I have to check this from the database The user selects services which he wants then accordingly the time is stored in the database.

The services has time duration. And the duration varies to services. As you know the time taken in Salon for different services. The duration is stored in the database. And then time duration needs to be added with the selected time and it has to check whether that time slot is available or not if not than either he has to select another time or another date. My database table name is Appointments.

Posted 30-Oct-14 23:19pm

Amit Jangid

Updated 30-Oct-14 23:31pm

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Arora_Ankit · Accepted Answer · 2014-10-30T23:38:00

Solution 1

So What Exactly you need?
A whole code?
What you have tried?
Follow this:-
Bind dropdown simply with a datatable that will have dates and other one with time
On selected Index Changed event write your logics.

This way you can handle dates:-

C#

var dtDate=new DataTable();

dtDate.Columns.Add("AppointmentDate",typeof(string));

for (var day = 0; day < 59; day++)
 {
   var drRow = dtDate.NewRow();
   drRow["AppointmentDate"] =  DateTime.Now.AddDays(day).ToString("MM/dd/yyyy");
   dtDate.Rows.Add(drRow);
 }

Posted 30-Oct-14 23:38pm

Arora_Ankit

Updated 31-Oct-14 1:08am

v3

Comments

Amit Jangid 31-Oct-14 5:49am

Yes I want code. I didn't try anything because I am unable to do anything. I am out of ideas.

Ajith K Gatty 31-Oct-14 6:17am

solution1 looks good. implement that.

Amit Jangid 31-Oct-14 6:28am

How to do the date part? I am not getting that. I want to show dates in dropdownlist.

Arora_Ankit 31-Oct-14 6:49am

declare a datatable
insert Today's Date
iterate a for loop from 1 to 60 and add that index in todays date to get required date insert that in datatable.
Then bind dropdown with that.

Amit Jangid 31-Oct-14 6:53am

Can you please provide code? I am new to this technology.

Arora_Ankit 31-Oct-14 7:09am

Please check the solution. I put the code how you can handle the datatable for dates.

Amit Jangid 31-Oct-14 7:49am

Actually I am not getting where to add this code?

Arora_Ankit 31-Oct-14 8:11am

add this code in Page_Load if you want to bind on page load
else wherever you want.

Amit Jangid · Accepted Answer · 2014-10-31T03:13:00

This is the simplest way I have found to display the dates.

C#

protected void Page_Load(object sender, EventArgs e)
   {
       DropDownList1.Items.Add(DateTime.Now.ToShortDateString());
       for (int i = 1; i <= 60; i++)
       {
           DropDownList1.Items.Add(DateTime.Now.AddDays(i).ToShortDateString());
       }
   }