connectionstring in session

Question

0.00/5 (No votes)

See more:

I have a problem i want to access connection string in my app. i have configured connection string in session like this.

XML

<configuration>
    <system.web>
        <roleManager enabled="true" />
        <authentication mode="Forms" />
        <compilation debug="true" targetFramework="4.0" />
    </system.web>
    <system.web>

        <sessionState mode="SQLServer" sqlConnectionString="Data Source=Sreekanth; Integrated Security=True; Database=Northwind" sqlCommandTimeout="30" cookieless="UseUri" timeout="20"></sessionState>
    </system.web>

</configuration>

i want to do update insert delete in my application i want to access this connection string. how to do i am not getting idea please help me thank you.

Posted 21-Jun-12 20:48pm

sreekanthv12

Add a Solution

2 solutions

Solution 1

have a look to Exploring Session in ASP.NET[^]

Posted 21-Jun-12 20:54pm

Prosan

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vani Kulkarni · Accepted Answer · 2012-06-21T20:56:00

SessionState configures the session state settings for the current application.

HTML

<sessionstate mode="Off|InProc|StateServer|SQLServer">
              cookieless="true|false"
              timeout="number of minutes"
              stateConnectionString="tcpip=server:port"
              sqlConnectionString="sql connection string"
              stateNetworkTimeout="number of seconds"/></sessionstate>

To access Connection String:

Connection string in .NET 2.0 config file
In the appSettings location, add a key named whatever you like to reference your connection string to.

XML

<appSettings>
<add key="myConnectionString" value="server=localhost;database=myDb;uid=myUser;password=myPass;" />
</appSettings>

To read the connection string from code, use the ConfigurationSettings class.

C#

string connStr = ConfigurationSettings.AppSettings("myConnectionString");

Now you have the connection string loaded from web.config into your string variable in code.

Connection string in .NET 3.5 (and above) config file
Do not use appsettings in web.config. Instead use the connectionStrings section in web.config.

XML

<connectionStrings>
<add name="myConnectionString" connectionString="server=localhost;database=myDb;uid=myUser;password=myPass;" />
</connectionStrings>

To read the connection string into your code, use the ConfigurationSettings class.

C#

string connStr = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;