Use DataGridViewCheckBoxColumn with Y an N values instead of boolean values

Question

Hi I know this may sound a little silly but I want to use a DataGridViewCheckBoxColumn on a field in a database that either contains 'Y', 'N', or blank values. I want the Y values to be checked and everything else to be unchecked.

I am using VB.NET by the way and any help with this would be appreciated. Also before anybody asks no I can't change the database field to boolean I have to just roll with it the way it is.

@Sathish yes that's what I want to do. Any ideas how to do that? — slister, Aug 25 '14 at 13:21
did you try doing it in SQL (create a boolean expression based on whetehr the column is Y or N) ? — Ňɏssa Pøngjǣrdenlarp, Aug 25 '14 at 13:31
@Plutonix that is a good idea, but I am an SQL noob so how would that work exactly? — slister, Aug 25 '14 at 13:38
the syntax depends on the DB a little, `([Coaching]='Y') AS myCoaching ` will work for MS Access - you eval the actual column and "alias" the result as a boolean `myCoaching` ... or perhaps `([TableName.Coaching]='Y')` — Ňɏssa Pøngjǣrdenlarp, Aug 25 '14 at 13:40

score 1 · Answer 1 · 2014-08-25T13:49:38.380

1

You can use a IValueConverter, something like this:

 public class YesNoToBooleanConverter : IValueConverter
 {

     public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
     {

        return ((value as string).Equals("Y")) ? true : false;
     }

     public object ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
     {
        return value;
     }
 }

In binding using converter, If you are using wpf, this how you bind it.

this just an example:

xmlns:local="clr-namespace:project.converter"

Under resources:

<Grid.Resources> <local:YesNoToBooleanConverter x:Key="YesNoToBooleanConverter" /> </Grid.Resources>

In your column

DataMemberBinding="{Binding Active, Converter={StaticResource YesNoToBooleanConverter}}"

edited Aug 25 '14 at 13:49

answered Aug 25 '14 at 13:25

Where would I put that? Also how would I bind that to my column? – slister Aug 25 '14 at 13:30
1

you can create a new class derived to : `IValueConverter` or use the existing class you have and derive it to `IValueConverter` – Aug 25 '14 at 13:33
1

just convert it to vb. – Aug 25 '14 at 13:52

score 0 · Answer 2 · answered Aug 25 '14 at 13:54

0

Try like this

get the output of query is boolean like this

select case when column1="Y" then true else false end as column from table1

after that assign that data source in datagridview

answered Aug 25 '14 at 13:54

Sathish

4,419
4
30
59

score 0 · Answer 3 · edited May 23 '17 at 12:01

As I said in a comment when answering one of your previous questions: I'm pretty sure I've done that before. Well guess what, I had, and the solution is pretty simple.

The DataGridViewCheckBoxColumn class has two properties to help you.

FalseValue: Gets or sets the underlying value corresponding to a cell value of true, which appears as a checked box.
TrueValue: Gets or sets the underlying value corresponding to a cell value of false, which appears as an unchecked box.

With Me.MyDataGridViewCheckBoxColumnInstance
    .FalseValue = "N"
    .TrueValue = "Y"
    .DataPropertyName = "MyYesNoDataColumnName"
End With

Use DataGridViewCheckBoxColumn with Y an N values instead of boolean values

3 Answers3