SQLInCode

  • Thread starter Thread starter gh
  • Start date Start date
G

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")
 
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.
 
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")
Click to expand...

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
 
Back
Top