convert string to checkbox

I am new to infragistics. I have an ultracombo wingrid that is being populated with a sql dataset.

One of the columns is an string and I need to convert it to a checkbox and pass the value when the checkbox is changed. It is set to a valuelist

I have read through the other forums and still can’t get it to work.

Hi Theresa,

You can accomplish this by using a DataFilter.

I have been working with that code but It references using "use an UltraCheckEditor as the Column's EditorControl and specify the DataFilter on the UltraCheckEditor rather than the Column's Editor"

In my ds I have a Boolean value that I need to convert to string Yes/No and a string field that I need to convert to boolean

Basically I am not following how to use the UltraCheckEditor  since I have two columns that I need to filter

Hi Theresa,

I wrote a sample project that handles both conversions. To treat the string column as a checkbox, I used the same approach as the knowledge base article. To treat the boolean column as a string, I wrote a new DataFilter. The sample is attached.

Attachments:

1. BooleanDataFilter.zip

I am writing in vb and you provided c#, anyway you can convert?

And just so I am making myself clear.  I have a Boolean in my dataset that I want to convert to "Yes"/"No".  And in another column I have a String field with two values (not "Yes"/"No") that I am converting to Boolean.

I have successfully changed the later in CheckEditorDataFilter but I can't apply that to the Boolean field because the values are different.

Public Function Convert(ByVal args As Infragistics.Win.EditorDataFilterConvertArgs) As Object Implements Infragistics.Win.IEditorDataFilter.Convert

Select Case args.Direction

Case ConversionDirection.EditorToOwner

args.Handled = True

Select Case CType(args.Value, CheckState)

Case CheckState.Checked

Return "35"

Case CheckState.Unchecked

Return "37"

Case CheckState.Indeterminate

Return String.Empty

End Select

Case ConversionDirection.OwnerToEditor

args.Handled = True

If args.Value = "35" Then

Return CheckState.Checked

ElseIf args.Value = "37" Then

Return CheckState.Unchecked

Else

Return CheckState.Indeterminate

End If

End Select

End Function

My recommendation is to use a separate data filter for each column.

I will convert the sample to VB, and update it to account for your clarifications.

That is my question. How do I setup different data filters for the two columns? 

Hi Theresa,

We actually came up with a solution that doesn’t require setting up a DataFilter for each column. I used a value list instead to map YES/NO to true/false on the boolean column. The sample is in VB and is attached here.

If you needed to apply a separate DataFilter to each column, you could just define each DataFilter in a separate class, then set each editor’s DataFilter property accordingly.

Attachments:

1. BooleanColumnVB.zip