Can't Make A Connection String In C#

I'm new to C# and don't know much! I have created a local database in C# 2012 and want to make a connection to it. I tested connection with its wizard and it said successfully conn

Solution 1:

It seems like you miss one backslash \ between (LocalDB) and v11.0:

myConnection.ConnectionString="Data Source=(LocalDB)\\v11.0;AttachDbFilename=C:\\Users\\jack\\Documents\\Visual Studio 2012\\Projects\\dictionary\\dictionary\\dictionaryDb.mdf;Integrated Security=True;Connect Timeout=30";

One back slash will be consider as escape character, two backslashes \\ will be treated as backslash. Alternative, do this (using @) to make your string character clearer:

myConnection.ConnectionString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\jack\Documents\Visual Studio 2012\Projects\dictionary\dictionary\dictionaryDb.mdf;Integrated Security=True;Connect Timeout=30";

You could also specify your connectionString in your app.config<connectionStrings> <add name="DefautConnection" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\jack\Documents\Visual Studio 2012\Projects\dictionary\dictionary\dictionaryDb.mdf;Integrated Security=True;Connect Timeout=30;" .. and so on which is not uncommon.