Control

Question

hi all I want to make project with DB made by SQL server and i want to make a setup file i do not know how to make the DB run on the user computer because the Connection String changing from computer to another i hope to help me in that? the second question i have form1 and form2 i called form2 from form1 by show dialog method how can i get the text from textbox that is in form2?

Ahmad · Answer

thanx alot i will try it.

Satish Kathi · Answer

Set the Data Source = (local) instead of computer name Data Source=(local)

Ahmad · Answer

thanx for replying me but i did not understand how the connection string will be the same the computer name will be changed so how the connection string will be the same

Satish Kathi · Answer

Set the Modifiers property of the Textbox in Form2 to Public . And the following code will retrieve Text of the TextBox in Form2 Form2 f = new Form2 (); f.ShowDialog(); string textFromForm2 = f.textBox1.Text;

Ryan Alford · Answer

if SQL Server is installed correctly on each machine then the connection string will be exactly the same on each machine.