How to use DataTable.Select() when the DataColumn.ColumnName contains a space?
I have a DataColumn that contains an space and I just couldn’t get the DataTable.Select(“Column Name=value) function to work.
So i found a solution on some other guys wordpress blog here.
The answer should be obvious to those who use SQL. In SQL to use a space, it often adds square brackets around the column names. [Column Name]. Yes, using square brackets is the solution.
String colName = "Column Name"; String Value = "some data"; DataTable.Select("[" + colName + "]='" + value + "'");