DataTable.Select problem

[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.
....."

[Carl Fenley]

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

"Alex Markov" <ma****@bgumail.bgu.ac.il> wrote in message
news:2f****************************@phx.gbl...

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.
...."