connection string not working

Question

using (SqlConnection conn = new SqlConnection("Data Source=SARAN-PC\SQLEXPRESS;Initial Catalog=ERP;integrated security=SSPI"))
{}

when i include this line in asp.net web application,it shows..(Unrecognised escape sequence as error) locating \S in the connection string... help me to connect.. Thanks a lot

Answer 1

It's the "\" in your string that C# is interpreting as an escape sequence (for example a carriage return).

You can either:

using (SqlConnection conn = new SqlConnection(@"Data Source=SARAN-PC\SQLEXPRESS;Initial Catalog=ERP;integrated security=SSPI")) {}

Note the @ symbol.

or, you could use a double backslash:

using (SqlConnection conn = new SqlConnection("Data Source=SARAN-PC\\SQLEXPRESS;Initial Catalog=ERP;integrated security=SSPI")) {}

Answer 2

using (SqlConnection conn = new SqlConnection("Data Source=SARAN-PC\\SQLEXPRESS;Initial Catalog=ERP;integrated security=SSPI")) {}

Or

using (SqlConnection conn = new SqlConnection(@"Data Source=SARAN-PC\SQLEXPRESS;Initial Catalog=ERP;integrated security=SSPI")) {}

Answer 3

Add the @ sign before the start of your string to ignore escape sequences.

new SqlConnection(@"Data Source=SARAN-PC\SQLEXPRESS;Initial Catalog=ERP;integrated security=SSPI")) 

Answer 4

All answers are correct but you shouldn't hardcode this string. Read it from resource or configuration file.