使用DataTable.Select 方法时,特殊字符的转义方法分享

public static string replace(string oldstr)
        {
            if (string.isnullorempty(oldstr))
            {
                return "";
            }
            string str2 = regex.replace(oldstr, @"[\[\+\\\|\(\)\^\*\""\]'%~#-&]", delegate(match match)
            {
                if (match.value == "'")
                {
                    return "''";
                }
                else
                {
                    return "[" + match.value + "]";
                }
            });
            return str2;
        }