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

Answer 1

Then mention with path. 

 

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

Answer 2

Mdf

Answer 3

Are you using sql server or mdf

?

 

Answer 4

Same Error

Answer 5

Just provide your database name

Answer 6

Database Name or Database Location  ?

Answer 7

Hi Methoun,

 

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

Answer 8

Here is config file

Answer 9

Here insert screen shoot

Answer 10

HI Methoun,

 

Please add some screen shots 

Answer 11

Now show the error

 

 

Additional information: Configuration system failed to initialize 

Answer 12

Change your sql connection code also,

 

App.config.cs

 

<configuration> <connectionStrings> <add name="Test" connectionString="Data Source=yourservername;Initial Catalog=yourdatabasename;Integrated Security=True" providerName="System.Data.SqlClient" /> </connectionStrings> </configuration>

 

In reference Add - > System.configuration

 

In Page,

 

using system.configurations;

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionString["Test"].toString());

Answer 13

Still now show thats error bro

Answer 14

HI Methoun,

 

What is your issue in that? 

Answer 15

<configuration><connectionStrings><add name="Test" connectionString="Data Source=.;Initial Catalog=D:\MESMANAGEMENT\MESMANAGEMENT\DATABASE\MESMANAGEMENT.MDF;Integrated Security=True" providerName="System.Data.SqlClient" /> </connectionStrings> </configuration>            ????????????

Answer 16

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,

 

<configuration> <connectionStrings> <add name="Test" connectionString="Data Source=.;Initial Catalog=OmidPayamak;Integrated Security=True" providerName="System.Data.SqlClient" /> </connectionStrings> </configuration>