Non Exact Find in DataView

[Guest]

I have a DataView with a string type column which is the sorted column.
Please help me, how to find a string in the column and I get the first
occurence of this string or substring.

Thank you!

 

[Miha Markic [MVP C#]]

Hi,

Use LIKE operator:
"ItemName LIKE '*product*'"

"ItemName LIKE '*product'"

"ItemName LIKE 'product*'"

You'll find more info in

DataColumn.Expression

..net help topic.

 

[Cor Ligthert]

Mihaly,

You can use for that in my opinion the datatable.select with the "Like
statement" and than after that with the keys of the founded row(s), a
dataview.find with those keys.

I hope this helps?

Cor