INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Jobs from Indeed

carriage return/line feed

carriage return/line feed

(OP)
How do I include carriage return/line feeds in my SQL strings?

I currently have code in this format :

strCallTypeUpdate = "declare @Number as char(26) " + "\r\n ";   (and so on...)

But this doesn't work.  Is there an equivalent to vbCrLf in C#?


Thanks,

lfc77

RE: carriage return/line feed

lfc77,
You should use Environment.NewLine!

JC

Jesus Christ! I was unaware of all the smileys available here at tek-tips.

RE: carriage return/line feed

Your code should work!
Environment.NewLine is exactly "\r\n";
The followings are equivalent in C#:

CODE

Environment.NewLine;
"\r\n";
(char)13 + (char)10;  
Example:

CODE

cmd.CommandText = "CREATE PROCEDURE getProducts " + Environment.NewLine +
                    "@CatID Int " + Environment.NewLine +
                    "AS " + Environment.NewLine +
                    "SELECT ID, Desc, Price, Stock " +
                    "FROM NWA.dbo.Products " +
                    "WHERE ID = @CatID"
-obislavu-

RE: carriage return/line feed

But Environment.NewLine isolates you from the platform.  If you run your code under Mono, it will produce the correct newline character sequence for your OS.

Chip H.

____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close