Styjun

Is differentiation as a map discontinuous?

Why is a road bike faster than a city bike with the same effort? & how much faster it can be?

What benefits does the Power Word Kill spell have?

Do we know the situation in Britain before Sealion (summer 1940)?

Fuel sender works when outside of tank, but not when in tank

What secular civic space would pioneers build for small frontier towns?

OSM Thunderforest API keys in QGIS3

Why did the Soviet Union not "grant" Inner Mongolia to Mongolia after World War Two?

Is the mass of paint relevant in rocket design?

Excel Solver linear programming - Is it possible to use average of values as a constraint without #DIV/0! errors or sacrificing linearity?

What is the difference between an astronaut in the ISS and a freediver in perfect neutral buoyancy?

Late 1970's and 6502 chip facilities for operating systems

Quick Yajilin Puzzles: Scatter and Gather

What exactly did this mechanic sabotage on the American Airlines 737, and how dangerous was it?

How to create fractional SI units (SI...sqrts)?

Examples of "unsuccessful" theories with afterlives

How to deal with a Homophobic PC

Is there any relation/leak between two sections of LM358 op-amp?

Can I take new (still in their boxes) PC parts in my checked in luggage?

Is it possible to encode a message in such a way that can only be read by someone or something capable of seeing into the very near future?

Does "as soon as" imply simultaneity?

Is it impolite to ask for halal food when traveling to and in Thailand?

what should be done first, handling missing data or dealing with data types?

Which place in our solar system is the most fit for terraforming?

Any C# WinApplication with Install Sheild Building to .exe with SqlServer Database

How do I calculate someone's age in C#?Calculate relative time in C#What is the difference between String and string in C#?Hidden Features of C#?Calling the base constructor in C#Cast int to enum in C#How do I enumerate an enum in C#?How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?Why is Dictionary preferred over Hashtable in C#?how to publish c# window application installer

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

i have compile the application to Setup.exe with Install Sheild in Visual studio 2015 with SQL server 2012. The application work on my computer but when i transfer Setup.exe it to clients computer it didnt work generate problem with client computer.

Need A way to handle the application with

1. I have attached the database to SQLSERVER Managment studio.



2. 
   

   I have
   change configuration File Data Source=""to client computer Address
   but still not working.

   
   
   

   public static string GetConnection()

   
   
   

   
   
    return ConfigurationManager.ConnectionStrings["MyCon"].ConnectionString;
   
   
   SqlConnection con = new SqlConnection(GetConnection());
   public Form1()
   
    InitializeComponent();
   
   
   private void button1_Click(object sender, EventArgs e)
   
   
    con.Open();
    SqlCommand cmd = new SqlCommand("Select EmpID from RegForm",con);
    int i= Convert.ToInt32(cmd.ExecuteScalar());
    if(i!=0)
    
    MessageBox.Show("value type is " + i);
    con.Close();
    MessageBox.Show("Connection is closed ");
    
   
   
   
   
   

   
   

I just want that this compile application Start working with setting path in configuration DataSource Attribute nd the programming start working with Active Database

c# .net

share|improve this question

edited Mar 28 at 17:58

Ibrar Ahmad

asked Mar 28 at 17:38

Ibrar AhmadIbrar Ahmad

622 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  That doesn't look like valid sql.
  
  – LarsTech
  Mar 28 at 17:44
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Lars Tech :the connection string is in App.config file let me share it with you. <connectionStrings> <add name="MyCon" connectionString="Data Source=RISESTARSQLEXPRESS;Initial Catalog=Z-JanPayroll;Integrated Security=True" providerName="System.Data.SqlClient" /> </connectionStrings>
  
  – Ibrar Ahmad
  Mar 28 at 17:46
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Doesn't change my comment. Look at your query. Copy and paste your code next time.
  
  – LarsTech
  Mar 28 at 17:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  change the query; on my machine it work fine but on client machine it didnt work
  
  – Ibrar Ahmad
  Mar 28 at 17:59
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You haven't told us what the errors are. "not working" is not a good diagnosis for us. Give us the exact exception message you are seeing.
  
  – LarsTech
  Mar 28 at 18:10
  

  
  
  
  

 | 
show 2 more comments

0

i have compile the application to Setup.exe with Install Sheild in Visual studio 2015 with SQL server 2012. The application work on my computer but when i transfer Setup.exe it to clients computer it didnt work generate problem with client computer.

Need A way to handle the application with

1. I have attached the database to SQLSERVER Managment studio.



2. 
   

   I have
   change configuration File Data Source=""to client computer Address
   but still not working.

   
   
   

   public static string GetConnection()

   
   
   

   
   
    return ConfigurationManager.ConnectionStrings["MyCon"].ConnectionString;
   
   
   SqlConnection con = new SqlConnection(GetConnection());
   public Form1()
   
    InitializeComponent();
   
   
   private void button1_Click(object sender, EventArgs e)
   
   
    con.Open();
    SqlCommand cmd = new SqlCommand("Select EmpID from RegForm",con);
    int i= Convert.ToInt32(cmd.ExecuteScalar());
    if(i!=0)
    
    MessageBox.Show("value type is " + i);
    con.Close();
    MessageBox.Show("Connection is closed ");
    
   
   
   
   
   

   
   

I just want that this compile application Start working with setting path in configuration DataSource Attribute nd the programming start working with Active Database

c# .net

share|improve this question

edited Mar 28 at 17:58

Ibrar Ahmad

asked Mar 28 at 17:38

Ibrar AhmadIbrar Ahmad

622 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  That doesn't look like valid sql.
  
  – LarsTech
  Mar 28 at 17:44
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Lars Tech :the connection string is in App.config file let me share it with you. <connectionStrings> <add name="MyCon" connectionString="Data Source=RISESTARSQLEXPRESS;Initial Catalog=Z-JanPayroll;Integrated Security=True" providerName="System.Data.SqlClient" /> </connectionStrings>
  
  – Ibrar Ahmad
  Mar 28 at 17:46
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Doesn't change my comment. Look at your query. Copy and paste your code next time.
  
  – LarsTech
  Mar 28 at 17:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  change the query; on my machine it work fine but on client machine it didnt work
  
  – Ibrar Ahmad
  Mar 28 at 17:59
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You haven't told us what the errors are. "not working" is not a good diagnosis for us. Give us the exact exception message you are seeing.
  
  – LarsTech
  Mar 28 at 18:10
  

  
  
  
  

 | 
show 2 more comments

i have compile the application to Setup.exe with Install Sheild in Visual studio 2015 with SQL server 2012. The application work on my computer but when i transfer Setup.exe it to clients computer it didnt work generate problem with client computer.

Need A way to handle the application with

1. I have attached the database to SQLSERVER Managment studio.



2. 
   

   I have
   change configuration File Data Source=""to client computer Address
   but still not working.

   
   
   

   public static string GetConnection()

   
   
   

   
   
    return ConfigurationManager.ConnectionStrings["MyCon"].ConnectionString;
   
   
   SqlConnection con = new SqlConnection(GetConnection());
   public Form1()
   
    InitializeComponent();
   
   
   private void button1_Click(object sender, EventArgs e)
   
   
    con.Open();
    SqlCommand cmd = new SqlCommand("Select EmpID from RegForm",con);
    int i= Convert.ToInt32(cmd.ExecuteScalar());
    if(i!=0)
    
    MessageBox.Show("value type is " + i);
    con.Close();
    MessageBox.Show("Connection is closed ");
    
   
   
   
   
   

   
   

I just want that this compile application Start working with setting path in configuration DataSource Attribute nd the programming start working with Active Database

c# .net

share|improve this question

edited Mar 28 at 17:58

Ibrar Ahmad

asked Mar 28 at 17:38

Ibrar AhmadIbrar Ahmad

622 bronze badges

share|improve this question

edited Mar 28 at 17:58

Ibrar Ahmad

asked Mar 28 at 17:38

Ibrar AhmadIbrar Ahmad

622 bronze badges

share|improve this question

edited Mar 28 at 17:58

Ibrar Ahmad

asked Mar 28 at 17:38

Ibrar AhmadIbrar Ahmad

622 bronze badges

asked Mar 28 at 17:38

Ibrar AhmadIbrar Ahmad

622 bronze badges

asked Mar 28 at 17:38

Ibrar AhmadIbrar Ahmad

622 bronze badges