code & query for check the date between two dates in asp.net

Question

1.00/5 (1 vote)

See more:

i am a beginner..........
i am doing a asp.net project digital car parking system.the user need to park the car in slots.for booking the slot,enter the Vehicle entry date and exit date.if one user book the slot in between two dates.next another user book the same slot at the same date.i need to prevent the booking at the same dates.please send me the code for checkig the date is between Vehicle Entry date and Vehicle Exit date.

Posted 15-Jan-13 18:38pm

sudeep4404

Add a Solution

Comments

Vani Kulkarni 16-Jan-13 0:40am

What have you tried till now? Would you post your code?

2 solutions

Add a Solution

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

Tharaka MTR · Answer 1 · 2013-01-15T20:48:00

Please check following link and get the idea and do it yourself

http://msdn.microsoft.com/en-us/library/system.datetime.adddays.aspx[^]
http://msdn.microsoft.com/en-us/library/system.datetime.compare.aspx[^]
http://www.codedigest.com/Articles/ASPNET/264_Working_with_DateTime_Object_and_Formatting_DateTime_Object_in_ASPNet.aspx[^]

if you get those data from the MS SQL database, you can use SQL DATEDIFF function.
(I preferd that way)
http://msdn.microsoft.com/en-us/library/ms189794.aspx[^]

Hemant Singh Rautela · Answer 2 · 2013-01-15T20:53:00

May be it helps you..

SQL

SELECT  slot_no , entry_date, exit_date
FROM    TBMORDER
WHERE   (entry_date < '10/12/2012') AND (exit_date > '10/12/2012') AND (slot_no = 9;)

Using above query you can check for slot no 9 is booked for not and its entry date and exit date also for your given date

Thanks
Asp.Net/C#.Net Help[^]
Hemant Singh

code & query for check the date between two dates in asp.net

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

code & query for check the date between two dates in asp.net

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us