How to deployment project database attachment other PC

Methoun Ahmed

I have a project which is developer tools use in C# and Sqlserver 2012 and deployment that,s project make install file.But,i face a error connect to database sqlserver.Here is my connection string.Here is my connection string....

SqlConnection con = new SqlConnection(@"Data Source=.;Initial Catalog=D:\MESMANAGEMENT\MESMANAGEMENT\DATABASE\MESMANAGEMENT.MDF;Integrated Security=True");

16 Replies

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

Ramesh Palanivel8y ago
Then mention with path.

Note : The same path should be present in client place aslo.
0
Methoun Ahmed8y ago
Mdf
0
Ramesh Palanivel8y ago
Are you using sql server or mdf
?
0
Methoun Ahmed8y ago
Same Error
0
Ramesh Palanivel8y ago
Just provide your database name
0
Methoun Ahmed8y ago
Database Name or Database Location ?
0
Ramesh Palanivel8y ago
Hi Methoun,

In configuration file, you have missed to mention your database name in initial catelog. PLease mention your database name there.
0
Methoun Ahmed8y ago
Here is config file
0
Methoun Ahmed8y ago
Here insert screen shoot
0
Ramesh Palanivel8y ago
HI Methoun,

Please add some screen shots
0
Methoun Ahmed8y ago
Now show the error

Additional information: Configuration system failed to initialize
0
Ramesh Palanivel8y ago
Change your sql connection code also,

App.config.cs

In reference Add - > System.configuration

In Page,

using system.configurations;

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionString["Test"].toString());
0
Methoun Ahmed8y ago
Still now show thats error bro
0
Ramesh Palanivel8y ago
HI Methoun,

What is your issue in that?
0
Methoun Ahmed8y ago
????????????
0
Ramesh Palanivel8y ago
HI Methoun,

You just move your connection string in to app.config file.Once you move it and get the connection string from app.config. While you deploying your application in client environment, the app.config file will be editable. you change the server name in that.

Please refer app.config for connection string,

0