D
DotNetJunkies User
I have data in my DataTable that lists multiple values in the Roles column which are space separated like this:
" AM AMB MCS DIO CO PM3 CAM "
I need to be able to query on this column to get back a list of rows such that the Roles are "AM" or "MCS":
strFilter = "(Roles like '* AM *' or Roles like '* MCS *')"
[Example dataview statement:
dv = new DataView(dTable, strFilter, strSort, DataViewState.CurrentRows)]
The hard part here is that I DON'T want "CAM" or "AMB" when I search for "AM" and that "AM" may be at the start or end of the column string value, hence the extra character (space) marking the beginning and ending of each value.
The query above works on the dataset in an Access database, but when I apply it using the filter string of the dataview (to populate a drop list on the fly) the space AFTER "AM" causes no results returned.
ALSO, I have similar problems trying to filter using wildcards WITHIN the string. Ex: in Access "D?O" would return "DIO", "DKO", "DJO", but not in this context.
Are there any suggestions or fixes for resolving these problems?
" AM AMB MCS DIO CO PM3 CAM "
I need to be able to query on this column to get back a list of rows such that the Roles are "AM" or "MCS":
strFilter = "(Roles like '* AM *' or Roles like '* MCS *')"
[Example dataview statement:
dv = new DataView(dTable, strFilter, strSort, DataViewState.CurrentRows)]
The hard part here is that I DON'T want "CAM" or "AMB" when I search for "AM" and that "AM" may be at the start or end of the column string value, hence the extra character (space) marking the beginning and ending of each value.
The query above works on the dataset in an Access database, but when I apply it using the filter string of the dataview (to populate a drop list on the fly) the space AFTER "AM" causes no results returned.
ALSO, I have similar problems trying to filter using wildcards WITHIN the string. Ex: in Access "D?O" would return "DIO", "DKO", "DJO", but not in this context.
Are there any suggestions or fixes for resolving these problems?