Connection String in C#.Net

Question

//SQL PART

Line 1 : string dd = "Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Users\HEX\Documents\Visual Studio 2008\Projects\cventry_address_book_0.1\cventry_address_book_0.1\addressbook.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True";

Line 2 :SqlConnection sqlconobj = new SqlConnection(dd);

Line 3: sqlconobj.Open();

---------Errors Output------------

Unexpected character'\'

checkout string literals in .net and read about verbatim string — Krishnaswamy Subramanian
– Krishnaswamy Subramanian, Commented Mar 16, 2013 at 17:57

Steve · Accepted Answer · 2013-03-16 17:55:28Z

3

In C# the backslash character has special meaning.
You need to double it or prefix your entire string with the Verbatim character @
And there is no need to put a double quote before and after the file name.
Formatting rules (the ending semicolon) allows spaces in path or file name for the AttachDbFileName

 string dd = @"Data Source=.\SQLEXPRESS;AttachDbFilename=" + 
             @"C:\Users\HEX\Documents\Visual Studio 2008\" + 
             @"Projects\cventry_address_book_0.1\cventry_address_book_0.1" + 
             @"\addressbook.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";

edited Mar 16, 2013 at 17:55

answered Mar 16, 2013 at 17:37

Steve

217k22 gold badges242 silver badges296 bronze badges

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

Comments

JLRishe · Accepted Answer · 2013-03-16 17:51:14Z

2

Try:

string dd = @"Data Source=.\SQLEXPRESS;AttachDbFilename=""C:\Users\HEX\Documents\Visual Studio008\Projects\cventry_address_book_0.1\cventry_address_book_0.1\addressbook.mdf"";Integrated Security=True;Connect Timeout=30;User Instance=True";

You need to escape the string by using the @ character. Alternative you could replace single \'s with \\.

edited Mar 16, 2013 at 17:51

JLRishe

102k19 gold badges138 silver badges171 bronze badges

answered Mar 16, 2013 at 17:37

Darren

71.2k24 gold badges141 silver badges146 bronze badges

4 Comments

JLRishe Over a year ago

Even if you use @, the quotes still need to be escaped using "".

Steve Over a year ago

@JLRishe have you tried? The ending semicolon removes the ambiguity of normal paths

JLRishe Over a year ago

@Steve The quotes may not be necessary at all; I'm not sure on that point and that's not what my comment was referring to. What I can say for sure is that Darren's answer was invalid (as in, would not compile) the way he entered it, because it had unescaped quotes midstring.

Steve Over a year ago

Never had the chance to test with a Sql Server db, but I can assure you that a simple Access database placed in a path with spaces don't need any double quote

Darin Dimitrov · Accepted Answer · 2013-03-16 17:52:05Z

1

You should escape the string by prefixing it with the @ character. Also you should wrap your SqlConnection instance in a using statement:

string dd = @"Data Source=.\SQLEXPRESS;AttachDbFilename=""C:\Users\HEX\Documents\Visual Studio 2008\Projects\cventry_address_book_0.1\cventry_address_book_0.1\addressbook.mdf"";Integrated Security=True;Connect Timeout=30;User Instance=True";
using (SqlConnection sqlconobj = new SqlConnection(dd))
{
    sqlconobj.Open();
}

edited Mar 16, 2013 at 17:52

answered Mar 16, 2013 at 17:37

Darin Dimitrov

1.0m276 gold badges3.3k silver badges3k bronze badges

Comments

Iswanto San · Accepted Answer · 2013-03-16 17:37:34Z

0

You need escape the \ character. Use this:

string dd = @"Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Users\HEX\Documents\Visual Studio 2008\Projects\cventry_address_book_0.1\cventry_address_book_0.1\addressbook.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True";

More: String literals

answered Mar 16, 2013 at 17:37

Iswanto San

18.6k13 gold badges60 silver badges79 bronze badges

Comments

Ivan Marinin · Accepted Answer · 2013-03-16 17:42:08Z

0

string dd = "Data Source=.\\SQLEXPRESS;AttachDbFilename=\"C:\\Users\\HEX\\Documents\\Visual Studio 2008\\Projects\\cventry_address_book_0.1\\cventry_address_book_0.1\\addressbook.mdf\";Integrated Security=True;Connect Timeout=30;User Instance=True";

answered Mar 16, 2013 at 17:42

Ivan Marinin

1283 silver badges9 bronze badges

Comments

nsconnector · Accepted Answer · 2013-03-16 17:46:03Z

0

This should be your query connection string

string dd = @"Data Source=.\SQLEXPRESS;AttachDbFilename=" + 
                            @"C:\Users\HEX\Documents\Visual Studio 2008\Projects\cventry_address_book_0.1\cventry_address_book_0.1\addressbook.mdf" 
                            + ";Integrated Security=True;Connect Timeout=30;User Instance=True";

answered Mar 16, 2013 at 17:46

nsconnector

8366 silver badges12 bronze badges

Collectives™ on Stack Overflow

Connection String in C#.Net

6 Answers 6

Comments

4 Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

4 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related