Ok here is my issue. I want to be able to have two complete table of employee names. Both tables contain all the employees in each one. I also want a column that declares a boolean value. True being that are either in the first table Checked In/Out, false being they aren't. I have the names loaded in a GridView on the front end page. Each name has a button by it. When the button is clicked it needs to set the value of that current row (which contains a name) to false, and declare the other table to true. Then update the lists. This moves an employee from being checked in to checked out and vice versa. My question is can this be done, and do you have any hints or know of any documentation I can use to accomplish this?

Yes, when the button is clicked, you can use the gridView_RowCommand() method and get the selected row from the GridViewEventArgs (RowIndex).

From there, if you've stored the data in a DataTable, you can update the value directly in the DataTable, and then use the SqlDataAdapter to update SQL.

If you look into Disconnected ADO.NET database access, GridView events and DataSets, you should be fine.

Regards,

Dominic