Sqldataadapter not accepting colums containing reserved word

  • Thread starter Thread starter archana
  • Start date Start date
A

archana

Hi all

I ma having problem in sqldataadapter.

In my sql database i have one table containing column name as 'Name and
address'. Here 'and' is reserved word which i am using in column name.
In sql server at a time of inserting data into the table it is working
properly.

But when i try to insert data through sqldataadapter in C#, it is
giving me error
' incorrect syntax near and'.

what i want it to enclose column name in [] so that it should not give
me any kind of erro.

Is there any way for enclosing columns in p[] in sqldataadapter so that
i can fire insert query by using sqldataadapter.

Or is there any alternative for inserting data into such table through
c#.

Any help will be truely appreciated.

Thanks in advance.
 
Hi,

You have to wrap your column in [] (you know that already) , how r u doing
it?

Post the code to better understand the problem.
 
Back
Top