Find row using * wildcard or similar (Like) with dataview/dataTabl

[=?Utf-8?B?UmljaA==?=]

Is it possible to use a wildcard like feature with Dataview.Find? Actually,
I tried that but did not get any rows. Is there some wildcard like feature
of the dataview or some other object that I could search/find rows in an
ADO.Net dataTable?

Or, am I stuck having to write a loop and search the loop for a substring of
an expression?

[=?Utf-8?B?S2VycnkgTW9vcm1hbg==?=]

Rich,

I think that Dataview.Find expects a key and looks for an exact match.

On the other hand, Datatable.Select will let you use the Like operator and
wildcards.

Kerry Moorman
"Rich" wrote:

Is it possible to use a wildcard like feature with Dataview.Find? Actually,
I tried that but did not get any rows. Is there some wildcard like feature
of the dataview or some other object that I could search/find rows in an
ADO.Net dataTable?

Or, am I stuck having to write a loop and search the loop for a substring of
an expression?

[jayeldee]

On Mar 8, 4:37 pm, Rich <[e-mail]:

Is it possible to use a wildcard like feature with Dataview.Find? Actually,
I tried that but did not get any rows. Is there some wildcard like feature
of the dataview or some other object that I could search/find rows in an
ADO.Net dataTable?

Or, am I stuck having to write a loop and search the loop for a substring of
an expression?

If you're searching text fields I know you can use
Table.Rows.Select("FieldName Like '%whatever%'") to return all the
rows that have the FieldName column matching 'whatever' in any part of
it. It returns them into an array of DataRow objects you can iterate
through.

[=?Utf-8?B?UmljaA==?=]

Thanks all for your replies. That was what I needed. Table.Rows.Select.

"Rich" wrote:

Is it possible to use a wildcard like feature with Dataview.Find? Actually,
I tried that but did not get any rows. Is there some wildcard like feature
of the dataview or some other object that I could search/find rows in an
ADO.Net dataTable?

Or, am I stuck having to write a loop and search the loop for a substring of
an expression?

[Cor Ligthert [MVP]]

Kerry,

I always have that same idea like you, however the Select Expression is
AFAIK the same as the rowfilter Expression, therefore I would not know why
it would not work.

Cor

"Kerry Moorman" <Ke**********@discussions.microsoft.comschreef in bericht
news:47**********************************@microsof t.com...

Rich,

I think that Dataview.Find expects a key and looks for an exact match.

On the other hand, Datatable.Select will let you use the Like operator and
wildcards.

Kerry Moorman
"Rich" wrote:

>Is it possible to use a wildcard like feature with Dataview.Find?
Actually,
I tried that but did not get any rows. Is there some wildcard like
feature
of the dataview or some other object that I could search/find rows in an
ADO.Net dataTable?

Or, am I stuck having to write a loop and search the loop for a substring
of
an expression?