C # DataTable function doesn't work with special characters #

Question

I have a datatable select like:

productData.Select("Name = 'AAA BBB # CCC'");

I know that the entry is there, it just does not work due to the # symbol. I tried to escape using [], for example:

productData.Select("Name = 'AAA BBB [#] CCC'");

but it still doesn't work. I know that for single quotes I double them, so it "becomes". But what other characters do I need to worry about and how to make this case work.

Answer 1

Do you definitely need to use DataTables? That is why I was always very nervous from text query to DataTable.

, LINQ. DataTable , .

var query = products.AsEnumerable()
                    .Where(row => row.Field<string>("Name") == "AAA BBB # CCC");

, .. , , , .

Answer 2

- ?

productData.Select(@"Name = 'AAA BBB # CCC'");