column name starts with a number. c# throws error.
I have a table in sql server 2000 which has a column whose name starts with a number("2ndName").
I have a c# code which updates the table by filling a Dataset.
When I issue an update, it throws the following error:-
"Incorrect Syntax near 2"
Query I use to build the adapter is "SELECT id, Name, [2ndName] FROM MyTBL WHERE 1 = 3" and the statement issued to update is "objAdapter.Update(objDSDB, "MyTBL")" when it throws the error "Incorrect Syntax near 2".
Any help to resolve this is appreciated.
Thanks in advance.