Apr 12, 2009 06:25 PM|gsr80|LINK
Need some guidance please. In my application, which allows employees to create time-off requests, I've got a Gridview that retrieves records from a Bookings table, and all records by default have a status of "1" or "Awaiting Authorisation" .
In my Gridview, i've got 2 button fields, one for "Authrorised" and one for "Not Authorised". I want the manager to be able to click either button and the database record to be updated.
For example, if the manager can see a time-off request for an employee, they can either press "Authorised" to change the status of the record to "2" , or press "Not Authorised" to change the status of the record to "3".
The relevant status numbers are linked to the Bookings table by another table.
I basically need to know the logic for the command to update the record when the appropriate button is clicked. I've got an SqlDataSource on my page and the connection is all set up. I just need to get the buttons to actually do something !