Currently i am using asp.net and visual c# to do appointment checking.
I having problem in doing validation which is if the database got same date and time record, it will display a message tell user the slot is booked and user have to reselect.
Web Form- Calander control, Listbox, Button
Database got a table call AppBooking
Stored Procedure
Create Procedure bookingcheck ( @App_Date Date, @App_Time nVarchar(50) )
As
IF EXISTs (SELECT * FROM AppBooking Where App_Date = @App_Date AND App_Time = @App_Time) RETURN 1 ELSE RETURN 0;
I have created the stored procedure however i don't how to implement it in the submit button and associate with insert value into database ...
Go to the complete details ...