connection string

Question

Hi,

   I am doing a product based project using visual studio 2008 wizard.So all the forms in this application done by drag and drop of dataset to the form.So the connection string created while creating my dataset.Suppose i completed my product and it purchased by a client.My question is if they run my application in their system is there any problem with connection string.If so how can i set the connection string for each customer

Answer 1

Hi,
Right click on any data source in your form and choose configure in the second step you can find option that ask you if you want to save the connection string in the configuration file if you check this, the connection string will be save in the configuration file and can be changed after you compile your application on the customer site no need to recompile you application, if you want to make the configuration automatic you can create a customer dialog form in the setup project and ask the customer to provide you with the connection string and you programmatically set this value inside the configuration file.

Here a good article for Jon Galloway which describes this:

http://weblogs.asp.net/jgalloway/archive/2006/10/29/Showing-a-Connection-String-prompt-in-a-WinForm-application.aspx

 Thanks

 

 

 

---

We are volunteers, if the reply help you mark it as your answer. thanks!!
My Blog

Answer 2

thanks i got the solution