I have a datagridviewcheckboxcolumn in a datagridview control. The dataset for the datagridview can be a singlerow to multiple rows of records. Users allow to check or un-check the datagridviewcheckboxcolumn. When the userput a"true value" to it it will update thesql database with the value from anothercolumn inthe same row in the datagridview control.

I need to achieve the following:

Thedatagridviewcheckboxcolumn should have only single "true value" orall "false value" at any time. My question is how to achieve this in datagridviewcheckboxcolumn. Also how to obtain the value from another columnat the same row where the datagridviewcheckboxcolumnjust assign a "true value" Thanks.