Solved

ASP.Net Connection String

Posted on 2014-02-04
3
324 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
Comment Utility
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
Comment Utility
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
Comment Utility
Thanks for the suggestion but this will not work for what we are trying to achieve.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
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…
This video discusses moving either the default database or any database to a new volume.

772 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

11 Experts available now in Live!

Get 1:1 Help Now