Solved

ASP.Net Connection String

Posted on 2014-02-04
3
337 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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Vb.net threads keep increasing 2 48
VS 2017 18 101
Need syntax help building hyperlink 2 38
disadvantage of code behind appoarch in asp.net 3 28
A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
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…

680 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