470,849 Members | 1,048 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,849 developers. It's quick & easy.

DataView.RowFilter question

For my webapp I'm building a search page where the user can search through
data stored in a xml file.
I thought I use the dataview Rowfilter property but it seems it only works
if the search text is exactly the same as the description text in the
datatable.

How, if possible, can I use RowFilter in a way that it will also select
those rows where the description contains the search text?

i.e.: description text = "This is a test"
Search text = "es"

This line would be shown because the search text is in the description text.

I tried with the LIKE operator but that seems to be the same as the =
operator.

any suggestions?

rg,
Eric
Apr 9 '06 #1
2 1026
Never mind...I knew it was simple it just didn't pop up....

I used "*es*" as the search text and it did it...

rg,
Eric
"Eric" <so*****@MicroZoft.com> schreef in bericht
news:44**********************@text.nova.planet.nl. ..
For my webapp I'm building a search page where the user can search through
data stored in a xml file.
I thought I use the dataview Rowfilter property but it seems it only works
if the search text is exactly the same as the description text in the
datatable.

How, if possible, can I use RowFilter in a way that it will also select
those rows where the description contains the search text?

i.e.: description text = "This is a test"
Search text = "es"

This line would be shown because the search text is in the description
text.

I tried with the LIKE operator but that seems to be the same as the =
operator.

any suggestions?

rg,
Eric

Apr 9 '06 #2
Never mind...I knew it would be simple...it just didn't pop up...

I used as the seach text: "*es*" and that did it...

rg,
Eric

"Eric" <so*****@MicroZoft.com> schreef in bericht
news:44**********************@text.nova.planet.nl. ..
For my webapp I'm building a search page where the user can search through
data stored in a xml file.
I thought I use the dataview Rowfilter property but it seems it only works
if the search text is exactly the same as the description text in the
datatable.

How, if possible, can I use RowFilter in a way that it will also select
those rows where the description contains the search text?

i.e.: description text = "This is a test"
Search text = "es"

This line would be shown because the search text is in the description
text.

I tried with the LIKE operator but that seems to be the same as the =
operator.

any suggestions?

rg,
Eric

Apr 9 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Ryan Moore | last post: by
8 posts views Thread by Dave Hagerich | last post: by
13 posts views Thread by Steve | last post: by
14 posts views Thread by Able | last post: by
8 posts views Thread by KC | last post: by
3 posts views Thread by Catullus | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.