client machine name and connection string

[rockyy]

Vb.net and sql server help…?
My application (exe) is made
Using .net (vb.net)
And Backend-sql sever
After making it into package and my client install it into his pc
See pic here-\ the computer name I m talking about

Suppose my client machine name is-hcl
And I already made all connections string with hcl\\sqlexpress using windows authentication in app.config
And after sometime he formats his pc and changed his pc name to= hcl-2 ??
Now the problem
Is there any way to get the new system name ???? to make connections
bcuz its not worth it to always making a new exe and giving it to him when he formats his pc???

 

[rockyy]

any help plzzz....its urgent

 

[Hack]

Can't you just grab the machine name, store it in a variable, and use that for running your connection code?

 

[rockyy]

ya exactly i want to grab the machine code everytime when it newly generated or formatted but i don't know the method how to do it can u explain it thanx

 

[Hack]

Well your program is not going to have anyway of knowing if the hard drive is new or just formatted so your program will grab the computer name every time it is run.

To do that you can use:

 Dim strMachineName As String = My.Computer.Name

And user strMachineName with your connection string.

 

[cjard]

Your connectionstring is stored in your xml config file

Just edit the file - that's why conn string is put in a config file in the first place!

 

[rockyy]

Your connectionstring is stored in your xml config file

Just edit the file - that's why conn string is put in a config file in the first place!

this already exist in my project file what modification should i made to it ..????

 <add name="WindowsApplication5.My.MySettings.llConnectionString"
      connectionString="Data Source=cjard\SQLEXPRESS;Initial Catalog=cjardl;Integrated Security=True"
      providerName="System.Data.SqlClient" /

should i add again one more parameter <add name="" connection string=""
i m confused