I have a dropdownlist which gets the data from a database table(emptyseats). I select an item (seat) from this dropdownlist and save it in a different table (occupiedseats).After this i want to delete the seat from the first table (emptyseats) to show that it is now occupied. My problem is the seat is only removed from the dropdownlist not the database, so this makes it available when i re-run the program. Moreover i want to re-bind the dropdownlist with the previously selected seat not included. Can someone point me in the right direction.
DropDownList1.Items.Remove(DropDownList1.SelectedItem);//im stuck with this