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 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 19:38pm
Comments
Vani Kulkarni 16-Jan-13 0:40am
   
What have you tried till now? Would you post your code?
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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

Solution 2

May be it helps you..

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
  Permalink  
v2

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