Does dataview.find support wildcards?

[Guest]

I'm trying to find the first record based on a string with wildcards.

Ex:
nº Name
0 John
1 Mary
2 Mariah
3 Mike

dataview.sort="name"
dataview.find("M*")

The above code do not work. Is there any way to do what I pretend to?

 

[Imran Koradia]

You could use the DataView.RowFilter property to filter the rows you want.
The RowFilter property takes in a string argument which determines how the
rows are filter. Supported filters are the same as for the
DataColumn.Expression which are documented here:
http://msdn.microsoft.com/library/d...fsystemdatadatacolumnclassexpressiontopic.asp

In your example, you would set the rowfilter as:

dataview1.RowFilter = "Name LIKE 'M*'"

hope that helps..
Imran.