Click here to Skip to main content
Rate this: bad
good
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 at 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
0 Zoltán Zörgő 320
1 CHill60 165
2 BillWoodruff 120
3 Peter Leow 120
4 bling 80
0 Sergey Alexandrovich Kryukov 9,423
1 OriginalGriff 6,891
2 Peter Leow 4,637
3 Zoltán Zörgő 4,304
4 CHill60 2,932


Advertise | Privacy | Mobile
Web02 | 2.8.150129.1 | Last Updated 16 Jan 2013
Copyright © CodeProject, 1999-2015
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