Solved

Using <sessionState sqlConnectionString="..." />  in WEB.CONFIG

Posted on 2004-10-03
3
928 Views
Last Modified: 2008-02-01
Hi,

I have web-app which uses SQL server to get/set data.

Where is the best place to hold the connection string data?

In WEB.CONFIG, attribute sqlConnectionString="..."  in tag <sessionState> used for session-data-saving, right?

10x, El.
0
Comment
Question by:eladka
3 Comments
 
LVL 4

Accepted Solution

by:
eozz_2000 earned 125 total points
ID: 12212797
I prefer to use me.Session("sqlConnectionString") = strConnectionString, and retrieve like this:

msgbox me.Session("sqlConnectionString")
0
 

Author Comment

by:eladka
ID: 12331559
Great !
It works ok
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

914 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now