Datagrid checkbox value update issue

[irene]

Hi, All,

I am trying to bulid a web application for user's to approve certain
information. On the web page, it shows a datagrid containing the
detail information from the database(SQL database). Checkbox values
are coming out from the database "approved"(bit datatype) column. I
can read the data from the database either by dataset or datareader
and the data is showing correctly on the web page. After user click
the checkbox value, I want to update the database based on that value.
How can I pass the checkbox value so that I will know which record
need to update then? The updatequery will be something like"Update
Table1 set Approved = 1, ApprovedBy = '" & User & "', ApprovedDate =
'" & today & "' where UserID = XXX"

Thanks.

Irene