[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

ASP.Net Connection String

Posted on 2014-02-04
3
Medium Priority
?
358 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 1500 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

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

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

Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
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…
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…

590 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