database connection string

Navneet Nayak

I am working on a window form.....where i am creating a database.

to connect in that database i need a connection string....

(Data Source=.\SQLEXPRESS;AttachDbFilename="c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\giftdb.mdf";Integrated Security=True;User Instance=True )

while inserting the above string, it is showing some error.... what is wrong with the above string.

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta9y ago
Accepted answer
@Navneet,
Have you checked the link that I had posted in earlier link? This will show how to connect the database.

Try this and make changes as highlighted .
@"Data Source=.\SQLEXPRESS;AttachDbFilename='c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\giftdb.mdf';Integrated Security=True;User Instance=True"
It has also been noticed that error posted by you, it seems that it contains some missing namespace in #28 etc.
Please read the post or article carefully posted by the authors.

Do mark as correct answer, if it resolves your issue.
Sandip G Patil9y ago
Just try it with

SqlConnection con = new SqlConnection(@"here your database connection string goes down");

Make sure that your connection string should be between " ".
Use @ as mentioned above
Navneet Nayak9y ago
#Amit

i need steps for connecton string....
can u provide it to me :)
Nitin Sontakke9y ago
What is the error? You will need to keep posting the errors as they change. As I stated earlier I have not used this kind of connection string.
Navneet Nayak9y ago
#Nitin

@"Data Source=.\SQLEXPRESS;AttachDbFilename=\"c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\giftdb.mdf\";Integrated Security=True;User Instance=True"

still error is coming...bold area from above string represents the error area...
Nitin Sontakke9y ago
You have not escaped the double quotes. You have removed them. Please compare your string with one posted by me.

I suggest, you just copy and paste relevant piece of code from my reply.
Navneet Nayak9y ago
#Nitin
(@"Data Source=.\SQLEXPRESS;AttachDbFilename=\c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\giftdb.mdf\;Integrated Security=True;User Instance=True");

I have written above string by escaping double quotes....
now error is not coming but, let me finish the code....
den i'll come back to u
Nitin Sontakke9y ago
Personally, I have never used the connection string with AttachDbFilename attribute. However, please try escaping your another set of double quotes with \ as shown below as an example:

new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=\"c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\giftdb.mdf\";Integrated Security=True;User Instance=True");
Navneet Nayak9y ago
yes,,,thanks...
i am beginner to this field...
thankx for suggession..

if u have any video link... plz provide........
Amit Gupta9y ago
Check this link, how to pass connection string
http://www.java2s.com/Tutorial/CSharp/0560__ADO.Net/SetAttachDbFilenameinconnectionstring.htm

I think you need to start learning c# from the beginning instead directly working on database.
Navneet Nayak9y ago
i have passed it in double quotes, but still error is comming....
plz help....

("Data Source=.\SQLEXPRESS;AttachDbFilename="c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\giftdb.mdf";Integrated Security=True;User Instance=True")

errors are:
Error 1 Unrecognized escape sequence c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 62 marriage_book

Error 2 Unrecognized escape sequence c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 93 marriage_book

Error 3 Unexpected character '\' c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 99 marriage_book

Error 4 Unexpected character '\' c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 104 marriage_book

Error 5 Unexpected character '\' c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 114 marriage_book

Error 6 Unexpected character '\' c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 133 marriage_book

Error 7 Unexpected character '\' c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 142 marriage_book

Error 8 Unexpected character '\' c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 156 marriage_book

Error 9 Unexpected character '\' c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 170 marriage_book

Error 10 ) expected c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 91 marriage_book

Error 11 Invalid token ':' in class, struct, or interface member declaration c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 92 marriage_book

Error 12 Invalid token '\' in class, struct, or interface member declaration c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 99 marriage_book

Error 13 Invalid token '\' in class, struct, or interface member declaration c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 104 marriage_book

Error 14 Invalid token '\' in class, struct, or interface member declaration c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 114 marriage_book

Error 15 ; expected c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 129 marriage_book

Error 16 Invalid token '\' in class, struct, or interface member declaration c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 142 marriage_book

Error 17 Invalid token '\' in class, struct, or interface member declaration c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 156 marriage_book

Error 18 Invalid token '\' in class, struct, or interface member declaration c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 170 marriage_book

Error 19 Invalid token '";Integrated Security=True;...' in class, struct, or interface member declaration c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 181 marriage_book

Error 20 The type or namespace name 'c' could not be found (are you missing a using directive or an assembly reference?) c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 91 marriage_book

Error 21 The type or namespace name 'users' could not be found (are you missing a using directive or an assembly reference?) c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 93 marriage_book

Error 22 The type or namespace name 'lipu' could not be found (are you missing a using directive or an assembly reference?) c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 100 marriage_book

Error 23 The type or namespace name 'documents' could not be found (are you missing a using directive or an assembly reference?) c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 105 marriage_book

Error 24 The type or namespace name 'visual' could not be found (are you missing a using directive or an assembly reference?) c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 115 marriage_book

Error 25 The type or namespace name 'Projects' could not be found (are you missing a using directive or an assembly reference?) c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 134 marriage_book

Error 26 'marriage_book' is a 'namespace' but is used like a 'type' c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 143 marriage_book

Error 27 'marriage_book' is a 'namespace' but is used like a 'type' c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 157 marriage_book

Error 28 The type or namespace name 'giftdb' could not be found (are you missing a using directive or an assembly reference?) c:\users\lipu\documents\visual studio 2010\Projects\marriage_book\marriage_book\Form1.cs 20 171 marriage_book
Amit Gupta9y ago
@Navneet
Connection string constructor needs string value. Pass it in double quote.

var connection = new SqlConnection(@"your connection string");