[Solved] How to implement Binded checkbox column

[Timothy]

How do you implement a checkboxcolumn to be checked if Binded value is 1, and unchecked if binded value is 0.

I have no problem getting the data into the table but this is what it looks like,

Hostname        IsChecked
TestName        1
TestName2      1
TestName3      0

Instead of the 1 or 0, I want a check box (checked if 1, unchecked if 0)

I am new to this so please help.

Thanks,
Tim 

[Maya]

Hi Timothy,

You may create an IValueConverter that gets the int-value and converts it to boolean. Afterwards, all you need to do is to define the GridViewCheckBoxColumn and bind it to the converted value. I am sending you a sample project illustrating the proposed solution.

Greetings,
Maya
the Telerik team

[Timothy]

You know how they always say Men will drive around for hours before asking for directions. Well I drove around for two days trying to figure this out.

Maya, thank you very much for the quick response. I took a look at the project you provided and I see now how you implemented the converter within the XAML.

I tested this out in my project and it worked perfectly. I have read a ton of your postings here and I must say Telrik is lucky to have you on their staff. Your technical prowess is outstanding.

I do have one question. Is there any way to flag my SQL table column type appropriately so I can avoid having to do the conversion in code? Currentl it is set to Int.

Thanks again!

Tim

[Maya]

Hi Timothy,

There is no problem to achieve that functionality in the data level by using the proper SELECT statement. You may either define a IF statement returning boolean on the required conditions or modify a  StoredProcedure so that it accomplishes the same goal. 

Regards,
Maya
the Telerik team