Tommyworker
2017-10-04T21:18:22Z
Hello together,
i have an Grid with 6 cols. in the col 1 there string values Like "Hamburg", "Berlin", "Munic".
Starting the form with the grid on it i will insert for the AFG.colAutofilter(1).FilterAsBase64String to filter the col
here the code:
Dim mB As String = "IN BERLIN"
Dim byt As Byte() = System.Text.Encoding.UTF8.GetBytes(mB)
IgAFM.ColAutoFilter(1).FilterAsBase64String = Convert.ToBase64String(byt)

i always get an error message.
Is my code wrong?
Regards Thomas
Igor/10Tec
2017-10-05T14:44:18Z
No, you can't convert clauses like "IN <something>" to base-64-string and use it in AutoFilterManager. You can assign only a saved filter you got earlier with the FilterAsBase64String property. It's a very complex string describing all what AutoFilterManager needs to know to restore the filter.

Read also this forum post:

AutoFilterManager get and set filter / cols programmaticaly