Hi guys,
Can anyone knows how to check time? My problem was:
I'm creating scheduling the usage of a certain room. For example, someone reserved room1 at 1pm to 3pm. then other one is trying to reserved room1 at 2pm to 5 pm.
How can I check that the room1 is not available because it was reserved at 1pm?
can someone help me pls.. thanks!
annir
Loading
Ruzive MazhanduPosted Aug 24, 2008, 1:09 PM
hi
yo issue can be addressed in two ways one using SQL code or C# code.using SQL as u retrieve the data(time) from the DB screen by placing the time in the condition part of the SQL.
annirPosted Aug 22, 2008, 4:29 AM
I have a database that will handle the time. I just selecting the time from the database.
Blocked AccountPosted Aug 22, 2008, 3:32 AM
Whenever u allot any room ,check that room is allotted or not.
If that room is alloted then check the input start time not ranging between the allotted range and input end time not ranging between the allotted range.