DataView的RowFilter特殊字元的處理

DataView的RowFilter裡面遇到的特殊字元要用"[]"括起來，單引號要換成"''"。

LIKE關鍵字進行過濾時，如果碰到特殊字元包含："[","]","%","*","'" 解決的方法如下：

dv.RowFilter = "[Code] like '%條件字串%'";

過濾條件字元處理後，內容如下：

string rowFilter=條件字串;

rowFilter=rowFilter.Replace("[", "[[ ")
                .Replace("]", " ]]")
                .Replace("*", "[*]")
                .Replace("%", "[%]")
                .Replace("[[ ", "[[]")
                .Replace(" ]]", "[]]")
                .Replace("\'", "''");

dv.RowFilter = "[Code] like '%" + rowFilter+ "%'";

轉：http://www.cnblogs.com/whinsh/archive/2010/07/28/1786618.html