I have to replace \\ with \ in C#

Question

2.00/5 (2 votes)

See more:

I has enter

T4INTERN - 03\SQLEXPRESS

in textbox, then it is append in the string builder

StringBuilder ConStr = new StringBuilder.

ConStr.Append(txtServerName.Text.Trim());

Then i store that string in

string connection_string =ConStr.ToString();

But it gives me like this

T4INTERN - 03\\SQLEXPRESS.

I have to remove that one \ from it.

What I have tried:

I have tried

connstring=connstring.Replace(@"\\",@"\");

But it is not working.

Posted 7-May-18 6:54am

Member 11776570

Updated 7-May-18 7:09am

Add a Solution

Comments

Thomas Daniels 7-May-18 12:54pm

"it gives me like this" - where exactly do you see that string?

Member 11776570 7-May-18 12:58pm

when i store it in the string variable
string connection_string =ConStr.ToString();

MadMyche 7-May-18 15:39pm

Generally it is not recommended to build a connection string via concatenation, for reasons that parallel SQL Injection; there is actually a set of Connection String Builder classes which should be used if you are programmatically creating them

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kornfeld Eliyahu Peter · Accepted Answer · 2018-05-07T07:10:00

Solution 1

It may sound strange but not all is what it seems to be...
The debugger will display string values as escaped string so " (double quote) will show as \" and \ (slash) will show as \\...
What character escape sequences are available? | C# Frequently Asked Questions[^]

You can tell Visual Studio not to do, by adding ',nq' to the variable name in the watch window...

Format Specifiers in C#[^]

Posted 7-May-18 7:10am

Kornfeld Eliyahu Peter

Updated 7-May-18 10:12am

v3

Comments

Thomas Daniels 7-May-18 13:30pm

+5, especially for that ,ng trick - learning something new every day! :)

Kornfeld Eliyahu Peter 7-May-18 13:46pm

Thank you...

Kornfeld Eliyahu Peter 7-May-18 16:11pm

Ops... That 'ng' of course is 'nq' (no quotes)... Fixed and added the page with more...

Maciej Los 7-May-18 15:38pm

5ed!

Kornfeld Eliyahu Peter 7-May-18 16:09pm

Thank you

BillWoodruff 8-May-18 7:42am

+5

Kornfeld Eliyahu Peter 8-May-18 7:45am

Thank you!