SQL connection string for local db

Question

I want to connect to database with this connection string

SqlConnection connection = new SqlConnection("Data Source=(LocalDB)\v11.0;AttachDbFilename="C:\Users\4L46D\Documents\Visual Studio 2013\Projects\create table\create table\Database1.mdf";Integrated Security=True");

but I get the following error: get red line on address of database file:

AttachDbFilename="C:\Users\4L46D\Documents\Visual Studio 2013\Projects\create table\create table\Database1.mdf

enter image description here

Could you please help to how write the connection string?

solution : use @ before first double quotation(") and delete " from database path . use like this :

SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\4L46D\Documents\Visual Studio 2013\Projects\create table\create table\Database1.mdf;Integrated Security=True");

i just copy connection string and paste to sqlconnection().i have upload the picture. — Ali Arghianey
– Ali Arghianey, Commented Apr 26, 2020 at 20:35
red line on address of database file (syntax error)AttachDbFilename="C:\Users\4L46D\Documents\Visual Studio 2013\Projects\create table\create table\Database1.mdf — Ali Arghianey
– Ali Arghianey, Commented Apr 26, 2020 at 21:57
How can i define the address of database file in connection string? — Ali Arghianey
– Ali Arghianey, Commented Apr 26, 2020 at 22:00

Hammad Shabbir · Accepted Answer · 2020-04-26 23:16:59Z

1

To use inverted commas with in string. you need to escape character with backslash i.e (\)

SqlConnection connection = new SqlConnection("Data Source=(LocalDB)\v11.0;AttachDbFilename=\"C:\\Users\\4L46D\\Documents\\Visual Studio 2013\\Projects\\create table\\create table\\Database1.mdf\";Integrated Security=True");

answered Apr 26, 2020 at 23:16

Hammad Shabbir

7411 gold badge7 silver badges13 bronze badges

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

2 Comments

Hammad Shabbir Over a year ago

Do you found this answer useful ?

Ali Arghianey Over a year ago

No .not work for me .thnx anyway .the solution added the post

Collectives™ on Stack Overflow

SQL connection string for local db

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related