Loading

In DataView how can use RowFilter.

Bagesh kumar singh

Hello,

I am useing rowfilter its working properly

DataView dv = new DataView(ds.Tables[0]);

dv.RowFilter ="FileName LIKE '%"+txtSearch.Text+"%'";

i am filtering the value according to filename. butting getting error when i am using ' as search patter. for other its working fine.please give the solution.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
If you mean that the contents of the textbox may contain a single quote which will mess up the LIKE clause, then you can guard against that by doubling it:

So instead of using txtSearch.Text in the filter expression, always use:

txtSearch.Text.Replace("'", "''")
Satyapriya Nayak12y ago
http://www.csharp-examples.net/dataview-rowfilter/