dropdown menu in gridview
i have a dropdown menu in a gridview. Dropdown menu items are "Confirmed, Cancelled, No Show".
I also have 2 tables: Appointment and CancelNoshow
<asp: TemplateField HeaderText="STATUS"...
<asp: DropDownList id="ddl_stat"...>
When i click on Edit button, the dropdown menu is populated with an Update button.
How can i do something like,
1. when i select Confirmed, it will update Status column in table Appointment.
2. when i select either Cancelled or No Show, a record will be deleted from Appointment table and it will be inserted in to CancelNoshow table.