sql server database connection not working in c#

Question

I'm trying to connect a table database I created within Visual Studio and used the connection string, but keep getting a bunch of errors? I need to do this multiple times but can't even get the first one to work + im not sure what's wrong

screenshot

this is the line of code I've used:

CSharp SqlConnection Con = new SqlConnection(
    @"Data Source=(LocalDB)\MSSQLLocalDB;
    AttachDbFilename="C:\Users\scara\Documents\nea2022 database.mdf";
    Integrated Security=True;
    Connect Timeout=30");

I've connected through the tools tab and "connect to database" and it said that it was successful, so I'm really not sure ://

Why not upload images of code/errors when asking a question? — Luuk
– Luuk, Commented May 8, 2022 at 15:20
"I'm trying to connect...... and it said that it was successful" Please make yourself clear, do you try to connect or was it successful ? — Luuk
– Luuk, Commented May 8, 2022 at 15:23
You're getting various syntax errors because you are not quoting quotes correctly. — RBarryYoung
– RBarryYoung, Commented May 8, 2022 at 15:28
AttachDbFilename is a really bad idea, it will cause copies to be made of your database, which are deleted when you close the connection. Just attach your database normally. Also you should keep your connection string in a settings file, which would have prevented this error in the first place — Charlieface
– Charlieface, Commented May 8, 2022 at 15:28
@Charlieface ohh, how would i store the connection string in a settings file? ive only really just started using sql servers and am just trying to follow a video right now — yana
– yana, Commented May 8, 2022 at 15:39

Shahaf Machluf · Accepted Answer · 2022-05-08 15:28:02Z

2

You should escape the inner quotes inside the connection string.

Use double quotes, for example:

CSharp SqlConnection Con = new SqlConnection(
    @"Data Source=(LocalDB)\MSSQLLocalDB;
    AttachDbFilename=""C:\Users\scara\Documents\nea2022 database.mdf"";
    Integrated Security=True;
    Connect Timeout=30");

answered May 8, 2022 at 15:28

Shahaf Machluf

631 gold badge1 silver badge7 bronze badges

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

Comments

Guru Stron · Accepted Answer · 2022-05-08 15:28:58Z

1

Use second double quotes to escape them inside the verbatim string:

SqlConnection Con = new SqlConnection(
    @"Data Source=(LocalDB)\MSSQLLocalDB;
    AttachDbFilename=""C:\Users\scara\Documents\nea2022 database.mdf"";
    Integrated Security=True;
    Connect Timeout=30");

answered May 8, 2022 at 15:28

Guru Stron

151k11 gold badges186 silver badges232 bronze badges

Collectives™ on Stack Overflow

sql server database connection not working in c#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related