i want to use dataview's filter for searching, then bind it with a datagrid for showing the results, now i got a textfield for user typing whatever they want to search, so far I¡¡only know how to use Like for search, for example my code is like:


 DataView1.RowFilter = "Title LIKE ' %" + textbox.text.trim.tostring() + "%'"

this works fine, however, it only can search from the begining of a record, for example, if I have a record with title 'Today is sunny!', then user will be able to get this title by typing in 'Today' or even just 'T' then all titles start with 'Today' or 'T' will be showed. however if user type 'is sunny' then it can't be shown. my question is how to make that happen? I hope this make sense, thanks everyone, I wish you all have a happen Christmas!

sorry my code was:
DataView1.RowFilter = "Title LIKE ' " + textbox.text.trim.tostring() + "%'"

i can't put % right after Like, it won't work.

Try:
DataView1.RowFilter = "Title LIKE " + "'%" + TextBox.Text.Trim.Tostring + "%'"

Jim

yes, it works, thanks so much!!!!!!thxxxxx

glad to help...

Jim

Yes it works, but only until the user types apostrophe ('), percent (%), asterisk (*) or square bracket ([). In this case it fails. You should escape the value using EscapeLikeValue method. More informations, how to escape values, see article DataView.RowFilter Expression Syntax.