using System;

using System.Data;

using System.Text;

​

public class Program

{

    public static void Main()

    {

        DataTable dt = new DataTable();

        dt.Columns.Add("xxx", typeof(string));

        var dr = dt.NewRow();

        dr[0] = "abc";

        dt.Rows.Add(dr);

        DataView dv = dt.DefaultView;

        //dv.RowFilter = " xxx like '[%%]'";

        //dv.RowFilter = " xxx like '%[]%'";

        dv.RowFilter = " xxx like '[%%]'";

        //dv.RowFilter = " xxx like '[a]'";

        //dv.RowFilter = " xxx like '%[b]%'";

        //dv.RowFilter = " xxx like '%[ab]%'";

        //dv.RowFilter = " xxx like '%[ab]%'";

        //Console.WriteLine(EscapeLikeValue("[hello]"));

        Console.WriteLine(dv.Count);

    }

​

    public static string EscapeLikeValue(string str)

    { // reference url: https://www.csharp-examples.net/dataview-rowfilter/

        StringBuilder sb = new StringBuilder();

        for (int i = 0; i < str.Length; i++)

        {

            char c = str[i];

            if (c == '*' || c == '%' || c == '[' || c == ']')

            {

                sb.Append("[").Append(c).Append("]");

            }

            else if (c == '\'')

            {

                sb.Append("''");

            }

            else if (c == '\\')

            {

                sb.Append("");

            }

            else

            {

                sb.Append(c);

            }

        }

​

        return sb.ToString();

    }

}