SQLInCode

[gh]

I was using the SQL in another program I had. When I try to use it in
the C# it will not work. The ASP.NET compiler does not like the single
quotes. Is there another way to do this with SQL?

Thanks
("SELECT A.ADDR1||'' ''||A.CITY||'', '' " +
"||STATE.ABBRV||'' ''||A.POSTALCODE AS CSZ")

[Teemu Keiski]

Quotes work if you escape them properly with \' or precede the string with
@ when you'd need to double the quotes as escape sequences would not be
processed.

But can't you use a stored query in Access or stored procedure in SQL Server
database, if you are using either of them? Inline SQL is bit awkward to
maintain.

--
Teemu Keiski
AspInsider, ASP.NET MVP
http://blogs.aspadvice.com/joteke
http://teemukeiski.net

"gh" <[e-mail] in message
news:uj**************@TK2MSFTNGP06.phx.gbl...

>I was using the SQL in another program I had. When I try to use it in the
C# it will not work. The ASP.NET compiler does not like the single quotes.
Is there another way to do this with SQL?

Thanks
("SELECT A.ADDR1||'' ''||A.CITY||'', '' " +
"||STATE.ABBRV||'' ''||A.POSTALCODE AS CSZ")

[Hans Kesting]

gh submitted this idea :

I was using the SQL in another program I had. When I try to use it in the C#
it will not work. The ASP.NET compiler does not like the single quotes. Is
there another way to do this with SQL?

Thanks
("SELECT A.ADDR1||'' ''||A.CITY||'', '' " +
"||STATE.ABBRV||'' ''||A.POSTALCODE AS CSZ")

string theSql = "SELECT A.ADDR1||' '||A.CITY||', ' " +
"||STATE.ABBRV||' '||A.POSTALCODE AS CSZ";

should compile fine. You don't need to double (or escape) the single
quotes inside the string, as they have no special meaning for a C#
string.

Hans Kesting