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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DataTable.Select problem 1
DataTable.Select problem 2
Apostrophe in Column value of DataTable select query 2
Dataview rowfilter 4
Cannot interpret token 5
Solution: Parsing a search string and creating an SQL where clause 3
SQL query things " I'll " is operator ll (?!) 3
DataAdapters, DataSets, DataTables 5

Back
Top