How to pass special characters in Update stmt!!

[Jay]

Hello,

I need to use Update Sql stmt from my page.

Some of the field values has apostrophes and and quotes.

How do I make ado.net ignore those characters?
Eg-
UPDATE ROOM SET HEIGHT='3' - 5"' WHERE RMNU='100'
Iam using c#.

Thanks.
Jay

[Erik Frey]

SQL server string literals allow two single quotes (apostrophes) to
represent a single quote. Double quotes don't matter.

So your line should be:

UPDATE ROOM SET HEIGHT='3'' - 5"' WHERE RMNU='100'

"Jay" <pr********@atginc.com> wrote in message
news:O5*************@TK2MSFTNGP09.phx.gbl...

Hello,

I need to use Update Sql stmt from my page.

Some of the field values has apostrophes and and quotes.

How do I make ado.net ignore those characters?
Eg-
UPDATE ROOM SET HEIGHT='3' - 5"' WHERE RMNU='100'
Iam using c#.

Thanks.
Jay

[Nedu N]

Jay,

You can use paramers in the sql query and you can pass whatever the special
characters you want to pass into the SQL query without any problem.
Use SqlCommand or OleDBCommand object and use its parameters collection for
your where clause or SET clause.

Thanks
Nedu
"Jay" <pr********@atginc.com> wrote in message
news:O5*************@TK2MSFTNGP09.phx.gbl...

Hello,

I need to use Update Sql stmt from my page.

Some of the field values has apostrophes and and quotes.

How do I make ado.net ignore those characters?
Eg-
UPDATE ROOM SET HEIGHT='3' - 5"' WHERE RMNU='100'
Iam using c#.

Thanks.
Jay

[William Ryan]

I second that...params are better in every regard that I can think of.
"Nedu N" <ne****@hotmail.com> wrote in message
news:eb**************@TK2MSFTNGP12.phx.gbl...

Jay,

You can use paramers in the sql query and you can pass whatever the special characters you want to pass into the SQL query without any problem.
Use SqlCommand or OleDBCommand object and use its parameters collection for your where clause or SET clause.

Thanks
Nedu
"Jay" <pr********@atginc.com> wrote in message
news:O5*************@TK2MSFTNGP09.phx.gbl...

Hello,

I need to use Update Sql stmt from my page.

Some of the field values has apostrophes and and quotes.

How do I make ado.net ignore those characters?
Eg-
UPDATE ROOM SET HEIGHT='3' - 5"' WHERE RMNU='100'
Iam using c#.

Thanks.
Jay