C# replace characters

Question

In a C# 2008 application, I am creating directory paths like the following in code:
C:\\temp\\testt1\\customer.

I need to be able to save this value in columns in a sql server 2008 r2 database. I
want the above directory to be saved as:

C:\temp\testt1\customer.

I have tried to replace \\ with \ using the replace string function but I am getting escape character errors.

Thus can you tell me how to resolve this problem?

Answer 1

You'd need to replace "\\" with @"\" :

ConfigurationSettings.AppSettings["Location"] + @"\" + Format_Date + @"\" + custName + "(" + pId + ")" + @"\";

Not really worth doing.

Answer 2

You are saying to have the value as: C:\ntemp\ntestt1\ncustomer? This will cause my value to

be C:\temp\testt1\customer in the database?

Answer 3

How would a verbatim work for the following: ConfigurationSettings.AppSettings["Location"] + "\\" + Format_Date + "\\" + custName + "(" + pId + ")" + "\\";

Answer 4

No. I'm saying to pass this C# string:

    "C:\\temp\\testt1\\customer"

to the database i.e. with doubled backslashes.

You could also use a 'verbatim' string (preceded by @) with single backslashes:

    @"C:\temp\testt1\customer"

Both of these represent the same string in C#.

 

Answer 5

Just save the string inclusive of the doubled backslashes which are needed in C# to distinguish the use of the backslash in escape sequences (such as \n, \t etc).

It should then save in the database as a path with single backslashes