setting Room back to available
i have a problem with my booking system. in the table rooms i have a column named isAvailable with datatype bit. when the Registereduser books a room from gridview with selected index this column is set to 0 where. all that works fine but now i have to update the table when a staff user deletes a selected booking. my idea is saving index of deleted row in array and compares index of table Rooms and table Bookings. if index is not found sets the isAvailable back to 1 thus making it available. is it a good idea? 

thanks for you help 
setting Room back to available
===

i have a problem with my booking system. in the table rooms i have a column named isAvailable with datatype bit. when the Registereduser books a room from gridview with selected index this column is set to 0 where. all that works fine but now i have to update the table when a staff user deletes a selected booking. my idea is saving index of deleted row in array and compares index of table Rooms and table Bookings. if index is not found sets the isAvailable back to 1 thus making it available. is it a good idea? 

thanks for you help 