Apostrophe in DataView RowFilter

Question

I have a DataView that I am trying to filter based on a dynamic row:

dv.RowFilter = "ContentTitle = '" + titleFilter + "'"; 

In some cases, the titleFilter contains an apostrophe that closes the filter request and causes an error.

Is there any way to avoid this character? I can not replace it.

Answer 1

Just add an apostrophe (aka quote) inside the titleFilter line using

 dv.RowFilter = "ContentTitle = '" + titleFilter.Replace("'", "''") + "'";