Sql connection string error, connection is aborted

I am creating a windows application.using sql server 2008.
I am getting connection string problem while connecting to .mdf file which is in this location c\folder\file.mdf.
first of all I have created 1 database in the sql with the tables. now I de-attached it. from c:\program files\sql server\data\mydb.mdf&mydb_log.ldf, I copied in desktop. now from my application when ever I am entering a text and then click create button event it ic creating a texbox1.text.mdf and textbox1_log.ldf. now I want to connect to this created database file.

I have give like this connection string but it is giving me connection is aborted and so on.

SqlConnection con = new SqlConnection(@"Data Source=.\SQLExpress;Integrated security=true;AttachDbFilename=c:\maq\" + textbox1.Text                                             +  ".mdf;Trusted_Connection=Yes");

Help me for this
I did this using .mdb it is successful but sql giving me trouble. I am new to use sql if I did any mistake please let me know I want learn a lot.

1 answer

I'm not sure if this is the cause of your error but specifying booth

Integrated security=true;

and

Trusted_Connection=Yes;

is redundant. They do the same (make use of windows authentication). Try remove one of them.

You should also specify a database name in your connection string as in here

http://www.connectionstrings.com/sqlconnection/attach-a-database-file-on-connect-to-a-local-sql-server-express-instance/

That's probably the cause of your error.