how deployment asp.net with 2 different Connections

Abdalla Elawad

Hi Guys

Please Help Me

I need to deploys app in the sever but in fact the system on the localhost contains with 2 ConnectionString in webconfig , at the same time when we install the database on the new server surely need to new connectionstring.

In your opinion what is the most appropriate solution to this problem ??

Thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abdalla Elawad8y ago
The following is connectionstring use on localhost / 2 conn sometimes Cash_PlanConn and sometimes Cash_PlanConne .

when i make deployement surely path of database in new server change .
+2
Abdalla Elawad8y ago
Hi Rajneesh Chaubey
thank you for answer , but that mean i will modify all new connection to on reports and datasets , gridview , webform etc.. modify app as whole
+2
Rajneesh Chaubey8y ago
In the end, we call a particular connection by add name(specified in connectionString url)
"Sales"
providerName="System.Data.SqlClient"
connectionString= "server=myserver;database=Products;uid=;pwd=" />

"NorthWind"
providerName="System.Data.SqlClient"
connectionString="server=.;database=NorthWind;Integrated Security=SSPI" />
In your code:
var conn1 = ConfigurationManager.ConnectionStrings["Sales"].ConnectionString;
var conn2 = ConfigurationManager.ConnectionStrings["NorthWind"].ConnectionString;
+2