DataTable.Select problem

  • Thread starter Thread starter Alex Markov
  • Start date Start date
A

Alex Markov

When I read table from Excel to DataTable object and one
of the field's names is with "?" (for example "class?")at
the end Select function throws the folowing exception:

"...
An unhandled exception of
type 'System.Data.SyntaxErrorException' occurred in
system.data.dll

Additional information: Cannot interpret token '?' at
position 6.
....."
 
Well, you'll need something like the QuotePrefix and QuoteSuffix properties
of the CommandBuilder. I think you need brackets ([]) around your suspect
column heading names.

- carl
 
Back
Top