What is count(1)?
I am using SQL server and my table is as follows:
Table AppointmentName: AppID, LastName, FirstName, Email, BirthDate, Slot.
Slot gets an SelectedIndexValue from the radio button on submitClick.
On Page_Load is where I need to have the SQL statement to see how many times the value from the column "Slot" has been used.