Click here to Skip to main content
12,761,018 members (31,474 online)
Rate this:
Please Sign up or sign in to vote.
See more: ASP.NET
i am a beginner..........
i am doing a 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 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 19:38pm
Vani Kulkarni 16-Jan-13 0:40am
What have you tried till now? Would you post your code?
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Rate this: bad
Please Sign up or sign in to vote.

Solution 2

May be it helps you..

SELECT  slot_no , entry_date, exit_date
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

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

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

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170217.1 | Last Updated 16 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100