Solved

ASP.Net Connection String

Posted on 2014-02-04
3
328 Views
Last Modified: 2014-03-05
I have a connection string in asp.net that controls a drop down in a Grid View. Based on the server that I am on either in Test, QA or Production the Database Instance names are different.

I want to be able to have the Connection String change v/s being hard coded. I tried a Session String but it doesn't like it;

Here is the base of what I have:

<asp:SqlDataSource ID="SQLConnection" runat="server"
   ConnectionString = "<%$ ConnectionStrings:DBConfig %>"
   SelectCommand = "SELECT Name FROM TableName "></asp:SqlDataSource>

What I want is to be able to replace the DBConfig with something dynamic that will distinguish the different instance names that it looks at in the web.config based on the server name.

Thanks
0
Comment
Question by:jeffreyjseaman
  • 2
3 Comments
 
LVL 9

Expert Comment

by:rawinnlnx9
ID: 39833331
If you are using Visual Studio 2010 or higher what you need is right here:

http://stackoverflow.com/questions/305447/using-different-web-config-in-development-and-production-environment
0
 
LVL 9

Accepted Solution

by:
rawinnlnx9 earned 500 total points
ID: 39833349
I would also recommend using TeamCity as a deployment strategy. Once configured it will handle all the details as it promotes from DEV to TEST and on to {YOURPICK}.

http://www.jetbrains.com/teamcity/

TeamCity is free unless you have tons of projets and buildagents going on.
0
 

Author Comment

by:jeffreyjseaman
ID: 39833561
Thanks for the suggestion but this will not work for what we are trying to achieve.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now