Deplying a C# Application with Database Connection!

[dennis_max27]

I've a application running now with a database connection and wanna make a deployment of it I tried much things. So that's why I'm asking now is there a easy guide to follow where I can see what to do. My connection string is hard coded, after I deployed the application it's still hard coded what is the way to let the Data Source (Computer Name) change automaticly to the new computername where it is installed? (return @"Data Source=KONING-AF02EAF7\SQLEXPRESS;Initial Catalog=KringVrienden;Integrated Security=True";) SofwareI'm using: Visual Studio 2008. SQL Server 2005 SQL Management Server 2005 Please help me. Dennis,

[loyal ginger]

I am assuming that each of your target machine has a db server installed. In your program use System.Environment.MachineName to get the machine name. Use this instead of the hard-coded machine name in your connection string. Hope this helps.

[vtchris peterson]

Rather than including your development machine name, simply use ".\SQLEXPRESS" or "(local)\SQLEXPRESS" as this will point to instance "SQLEXPRESS" on the local machine.