connection string in with a local db c# windows forms

Question

I've created a database using Visual Studio 2015 by adding it locally as a mdf file

The exception that gets thrown is Format of the initialization string does not conform to specification starting at index 81.

I'm building a Windows Forms application.

My connection string looks like this string cs = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\TestDb.mdf;Integrated";

bobek · Accepted Answer · 2017-01-08 00:30:00Z

2

You can user Visual Studio's server explorer to connect to your DB and then you'll get the correct connection string:

answered Jan 8, 2017 at 0:30

bobek

8,0388 gold badges41 silver badges76 bronze badges

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

2 Comments

mate, you made my life soooo much easier!! I did not know that detail in VS thanky you very much!!!

Glad I could help. Good luck.