'Datatable rows select operation showing error when column name has special characters. (C#)
I am trying to perform select operation on a datatable to extract some values from a column. The column that I am targeting has some special characters in it. so the error message is saying,
An exception has occured: Cannot interpret token ']' at position
the syntax that I am using is this,
DataRow[] DataRows = dataSet.Tables["ParentTable"].Select("[ColumnName[somText]]");
I have referred the docs, where they talk about the use of escape sequences in these type of cases, here is the link to that particular section
let me know your solutions.
Solution 1:[1]
Suggestion from Lei Yang, worked!
Select(@"[ColumnName[somText\]]")
you can read more about it here.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | DeepDev |
