I have a pre-existing database which I am coding to, so I can't change the data stored in the SQL-Server 2005 database.

My application uses the DataGridView to maintain the data. There is a yes/no field that I would like to bind a checkbox to. The field is a character field in the database, and holds either Y or N. So, here's the question.

I know how to set the column to be a checkbox, I think, but I don't know how to map it so that it reads/stores a "Y" value as checked and a "N" value as unchecked.

Any ideas how I do this?