In a recent project I was attempting to list data from a configuration settings database table. The values were boolean but stored as a 'Y' or a 'N' so that only one set of SQL's was needed to be written, as the product supports both Oracle and SQL Server.
When I first put the GridView together, I was surprised to find that there was no Value property for the asp:checkbox nor could you bind any other column in a database but a 'bit' column to it.
The only solution I could come up with was to create a custom Checkbox and implement the feature.
Click here to keep reading and get the code...