How to deployment project database attachment other PC

Question

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");

Ramesh Palanivel · Answer

Then mention with path. Note : The same path should be present in client place aslo.

Methoun Ahmed · Answer

Mdf

Ramesh Palanivel · Answer

Are you using sql server or mdf ?

Methoun Ahmed · Answer

Same Error

Ramesh Palanivel · Answer

Just provide your database name

Methoun Ahmed · Answer

Database Name or Database Location ?

Ramesh Palanivel · Answer

Hi Methoun, In configuration file, you have missed to mention your database name in initial catelog. PLease mention your database name there.

Methoun Ahmed · Answer

Here is config file

Methoun Ahmed · Answer

Here insert screen shoot

Ramesh Palanivel · Answer

HI Methoun, Please add some screen shots

Methoun Ahmed · Answer

Now show the error Additional information: Configuration system failed to initialize

Ramesh Palanivel · Answer

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());

Methoun Ahmed · Answer

Still now show thats error bro

Ramesh Palanivel · Answer

HI Methoun, What is your issue in that?

Methoun Ahmed · Answer

????????????

Ramesh Palanivel · Answer

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,

How to deployment project database attachment other PC

Answers (16)