Connection string based on the Database Environment c#

 Connection string based on the Database Environment c# sample:

 

<%

@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!

DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<

html xmlns="http://www.w3.org/1999/xhtml">

<

head runat="server">

<title>Untitled Page</title>

</

head>

<

body>

<form id="form1" runat="server">

<asp:ScriptManager ID="ScriptManager1" runat="server" />

<div>

<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">

</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ProviderName="System.Data.SqlClient"

DataSourceMode="DataReader"

SelectCommand="SELECT * FROM [mntsold]"></asp:SqlDataSource>

</div>

</form>

</

body>

</

html>

 

using

System;

using

System.Data;

using

System.Configuration;

using

System.Web;

using

System.Web.Security;

using

System.Web.UI;

using

System.Web.UI.WebControls;

using

System.Web.UI.WebControls.WebParts;

using

System.Web.UI.HtmlControls;

public

partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (System.Environment.GetEnvironmentVariable("COMPUTERNAME").ToString() == "xxxxxxx")

{

Response.Write(

"from test database");

SqlDataSource1.ConnectionString =

ConfigurationManager.ConnectionStrings["JDE_RKConnectionString"].ConnectionString;

}

if (System.Environment.GetEnvironmentVariable("COMPUTERNAME").ToString() == "ITWEB1223")

{

Response.Write(

"from production database");

SqlDataSource1.ConnectionString =

ConfigurationManager.ConnectionStrings["JDE_PRODUCTIONConnectionString"].ConnectionString;

}

 

}

}