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
Create Procedure bookingcheck ( @App_Date Date, @App_Time nVarchar(50) )
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 table. Kindly if you could help me in solving the problem. Thank you.
View Complete Post