What is the correct syntax in c# to create a line break in the middle of a mysql string? [duplicate]

Question

Possible Duplicate:
Multiline String Literal in C#

I'm probably not asking the right questions of Google to find my answer. I just want to keep my code neat without having a really long string on one line. I want to move to the next line without breaking the string.

cmd.CommandText = "UPDATE players SET firstname = CASE id WHEN 1 THEN 'Jamie' WHEN 2 THEN 'Steve' WHEN 3 THEN 'Paula' END WHERE id IN (1,2,3)";

For example, I would like to break this into two lines without affecting the string. All help would be appreciated.

@ColeJohnson \n won't work on source file.

Lews Therin
– Lews Therin

2012-09-28 17:49:35 +00:00
Commented Sep 28, 2012 at 17:49 — Lews Therin
– Lews Therin, Commented Sep 28, 2012 at 17:49

Joachim Isaksson · Accepted Answer · 2012-09-28 17:58:07Z

6

I suspect what you want is to use the @ for verbatim string literals; the advantage of verbatim strings is that escape sequences are not processed, and that they can span multiple lines.

cmd.CommandText = @"UPDATE players 
                    SET firstname = 
                      CASE id 
                        WHEN 1 THEN 'Jamie' 
                        WHEN 2 THEN 'Steve' 
                        WHEN 3 THEN 'Paula' 
                      END 
                    WHERE id IN (1,2,3)";

edited Sep 28, 2012 at 17:58

answered Sep 28, 2012 at 17:50

Joachim Isaksson

182k28 gold badges297 silver badges307 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

webby68 Over a year ago

This was perfect. I'm sure the others work equally as well. Thanks to all who helped.

Dmytro · Accepted Answer · 2012-09-28 17:51:04Z

4

Use @ symbol before string. It will say to compiler that string is multiline.

cmd.CommandText = @"UPDATE players 
                    SET firstname = CASE id 
                        WHEN 1 THEN 'Jamie' 
                        WHEN 2 THEN 'Steve' 
                        WHEN 3 THEN 'Paula' 
                        END WHERE id IN (1,2,3)";

answered Sep 28, 2012 at 17:51

Dmytro

17.3k28 gold badges88 silver badges133 bronze badges

Comments

Claudio Redi · Accepted Answer · 2012-09-28 17:50:19Z

3

You could use @ in fronf of your string. This is called Verbatim String Literal

cmd.CommandText = @"
 UPDATE players 
 SET firstname = CASE id 
                 WHEN 1 THEN 'Jamie' 
                 WHEN 2 THEN 'Steve' 
                 WHEN 3 THEN 'Paula' 
                 END 
 WHERE id IN (1,2,3)";

answered Sep 28, 2012 at 17:50

Claudio Redi

68.6k15 gold badges138 silver badges161 bronze badges

Comments

Scott Selby · Accepted Answer · 2012-09-28 17:50:13Z

1

like this

cmd.CommandText = "UPDATE players SET firstname =" +
   " CASE id WHEN 1 THEN 'Jamie' WHEN 2 THEN 'Steve' WHEN 3" + 
   " THEN 'Paula' END WHERE id IN (1,2,3)";

answered Sep 28, 2012 at 17:50

Scott Selby

9,58012 gold badges63 silver badges97 bronze badges

2 Comments

Scott Selby Over a year ago

@ works as well, keep in mind with the way I showed , you have to remember to space at the beginning of the next line as prevent concatinating 2 words that aren't supposed to be

Scott Selby Over a year ago

@webby68 - its good to remember this as an option , even though it doesn't work quite as cleanly as the @ approach - if you ever have to write the same thing in VB.Net , the @ before a string is not allowed

Joel Etherton · Accepted Answer · 2012-09-28 17:50:15Z

0

It's called concatenation:

cmd.CommandText = "UPDATE players SET firstname" +
    " = CASE id WHEN 1 THEN 'Jamie' WHEN 2 THEN 'Steve'" +
    " WHEN 3 THEN 'Paula' END WHERE id IN (1,2,3)";

answered Sep 28, 2012 at 17:50

Joel Etherton

37.5k10 gold badges92 silver badges106 bronze badges

Comments

Tim Destan · Accepted Answer · 2012-09-28 17:50:18Z

0

Like this?

cmd.CommandText = "text text" +
  "text text";

answered Sep 28, 2012 at 17:50

Tim Destan

2,02812 silver badges16 bronze badges

Comments

Joel Etherton · Accepted Answer · 2012-09-28 17:50:50Z

0

Simpley concatenate your strings as follows:

cmd.CommandText = "UPDATE players SET firstname = CASE id WHEN 1 " 
cmd.CommandText +="THEN 'Jamie' WHEN 2 THEN 'Steve' WHEN 3 THEN 'Paula' END WHERE id IN (1,2,3)";

edited Sep 28, 2012 at 17:50

Joel Etherton

37.5k10 gold badges92 silver badges106 bronze badges

answered Sep 28, 2012 at 17:50

JSK NS

3,4542 gold badges30 silver badges42 bronze badges

Collectives™ on Stack Overflow

What is the correct syntax in c# to create a line break in the middle of a mysql string? [duplicate]

7 Answers 7

1 Comment

Comments

Comments

2 Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

1 Comment

Comments

Comments

2 Comments

Comments

Comments

Comments

Linked

Related