bamapie
asked on
session variable in ASPX file
Consider the code below.
See that connection string referenced there with the angle bracket-percent markup? That's great.
But my app is going to use ConnectionString #1 if we're running in Production mode, and ConnectionString #3 if we're running in Test mode. Connection strings are read-only, so it's not like I can use a 3rd connection string "placeholder" that's assigned #1 or #2 at runtime, based on whether we're running in Production mode or Test mode.
So I'd like to put a session variable in there, instead of a read-only connection string. I want to do something like:
ConnectionString="<%$ Session["WhichConnectionSt
What should that look like? How do I go about this?
Thanks
See that connection string referenced there with the angle bracket-percent markup? That's great.
But my app is going to use ConnectionString #1 if we're running in Production mode, and ConnectionString #3 if we're running in Test mode. Connection strings are read-only, so it's not like I can use a 3rd connection string "placeholder" that's assigned #1 or #2 at runtime, based on whether we're running in Production mode or Test mode.
So I'd like to put a session variable in there, instead of a read-only connection string. I want to do something like:
ConnectionString="<%$ Session["WhichConnectionSt
What should that look like? How do I go about this?
Thanks
in the web.config file there is a setting <compilation debug="true" />
if this value is true means its debug code and if its false its release version of website
so in code you can use the following
#if DEBUG
-- get debug or test connection string
#elseif
-- production connection string
#endif
the above code will get you going as i am also using the same method in my solutions
if this value is true means its debug code and if its false its release version of website
so in code you can use the following
#if DEBUG
-- get debug or test connection string
#elseif
-- production connection string
#endif
the above code will get you going as i am also using the same method in my solutions
ASKER
Deepu:
1. I don't see where you set PRODUCTION or TEST "on". I see where they're declared as options, but not where you define which mode you're in.
2. That's great that you assign the Session variable in the web.config, but my stated problem is that I can't figure out how to use that value inside the ASPX page.
1. I don't see where you set PRODUCTION or TEST "on". I see where they're declared as options, but not where you define which mode you're in.
2. That's great that you assign the Session variable in the web.config, but my stated problem is that I can't figure out how to use that value inside the ASPX page.
hi,
Please refer the following link
http://odetocode.com/Blogs/scott/archive/2005/12/02/conditional-compilation-in-asp-net-2-0.aspx
this will make clear understanding of what i mean.
Deepu
Please refer the following link
http://odetocode.com/Blogs/scott/archive/2005/12/02/conditional-compilation-in-asp-net-2-0.aspx
this will make clear understanding of what i mean.
Deepu
try what i have suggested
there is only one setting in the web config and nothing else except for setting the connection string section as shown in my comment
there is only one setting in the web config and nothing else except for setting the connection string section as shown in my comment
Hi ,
You can do the configuration in Project-> properties also,
Please refer the picture attached,
You can do the configuration in Project-> properties also,
Please refer the picture attached,
ASKER
Thank you guys. Back to my original question:
>ConnectionString="<%$ Session["WhichConnectionSt
I already have an indicator, in the Session, of whether I'm in TEST or PROD mode.
I like my method, because it doesn't require different values in web.config. It doesn't require precomp directives or anything like that.
But I want to use my connection string in my ASPX page, in place of where it has web.config connection strings:
<asp:SqlDataSource
ID="vwPalletManagerEvents"
runat="server"
ConnectionString="<%$ ConnectionStrings:RSSQL1Co
See that connection string between the percent signs? I don't want that. I want to use my Session variable connection string there in a clean, elegant way.
Thanks again.
>ConnectionString="<%$ Session["WhichConnectionSt
I already have an indicator, in the Session, of whether I'm in TEST or PROD mode.
I like my method, because it doesn't require different values in web.config. It doesn't require precomp directives or anything like that.
But I want to use my connection string in my ASPX page, in place of where it has web.config connection strings:
<asp:SqlDataSource
ID="vwPalletManagerEvents"
runat="server"
ConnectionString="<%$ ConnectionStrings:RSSQL1Co
See that connection string between the percent signs? I don't want that. I want to use my Session variable connection string there in a clean, elegant way.
Thanks again.
have a look at the following link comment no. 12
http://www.codeguru.com/forum/showthread.php?t=372918
http://www.codeguru.com/forum/showthread.php?t=372918
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Have macro for this declare your macros in web.config,
<system.codedom>
<compilers>
<compiler compilerOptions="/d:DEBUG,
</compilers>
</system.codedom>
#if PRODUCTION
Session["WhichConnectionSt
#endif
#if TESTMODE
Session["WhichConnectionSt
#endif
Hope this will help you
Regards
Deepu