Sqldataadapter not accepting colums containing reserved word

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

[Ignacio Machin \( .NET/ C# MVP \)]

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.

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"archana" <tr**************@yahoo.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

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.