not 'getting' asp.net 2.0's web configuration tool

[Darrel]

I haven't made it very far into my first 2.0 project.

In the past, to connect to a DB, I'd store the connection string in
web.config and just grab it from my codebehind page:

connectionStrin g = ConfigurationSe ttings.AppSetti ngs("dbConnecti on")

Well, 2.0 is telling me that is deprecated. And via some googling, it seems
like I'm not even supposed to be touchiing the web config file much anymore
and using the whole Website Configuration Wizard.

Can anyone explain how this new concept works? Where do I now stick my db
connection string and how to I access it? Where is it stored? It also talks
about roles/permissions in the Conciguration wizard. Does that refer to
users of the application I'm building? Do I no longer create my own forms/db
tables to maintain users with admin login priviliges?

-Darrel

[Ken Cox - Microsoft MVP]

You're not obligated to use the tool. If you add your own configuration
elements, the wizard will pick them up the next time you run it.

Here are some examples and links that should get you going:

Access:

<configuratio n>
<appSettings/>
<connectionStri ngs>
<add name="blrpConne ctionString"
connectionStrin g="Provider=Mic rosoft.Jet.OLED B.4.0;Data
Source=|DataDir ectory|\blrp.md b;Persist Security Info=True"
providerName="S ystem.Data.OleD b"/>
</connectionStrin gs>
<system.web>
SQLExpress
<connectionStri ngs>
<add
name="LocalSqlS erver"
connectionStrin g="data source=.\SQLEXP RESS;Integrated
Security=SSPI;A ttachDBFilename =|DataDirectory |aspnetdb.mdf;U ser
Instance=true"
providerName="S ystem.Data.SqlC lient"
/>
</connectionStrin gs>
Storing and Retrieving Connection Strings

http://msdn2.microsoft.com/en-us/lib...94(VS.80).aspx

"Darrel" <no*****@nospam .com> wrote in message
news:OI******** ******@TK2MSFTN GP02.phx.gbl...

I haven't made it very far into my first 2.0 project.

In the past, to connect to a DB, I'd store the connection string in
web.config and just grab it from my codebehind page:

connectionStrin g = ConfigurationSe ttings.AppSetti ngs("dbConnecti on")

Well, 2.0 is telling me that is deprecated. And via some googling, it
seems like I'm not even supposed to be touchiing the web config file much
anymore and using the whole Website Configuration Wizard.

Can anyone explain how this new concept works? Where do I now stick my db
connection string and how to I access it? Where is it stored? It also
talks about roles/permissions in the Conciguration wizard. Does that refer
to users of the application I'm building? Do I no longer create my own
forms/db tables to maintain users with admin login priviliges?

-Darrel

[Darrel]

You're not obligated to use the tool. If you add your own configuration
elements, the wizard will pick them up the next time you run it.

Here are some examples and links that should get you going:

Thanks, Ken! That was simple once I knew. You'd think that if VS.net can
tell you something is deprecated, it could also give you a hit as to what to
replace it with ;o)

I noticed that my DB connection string is now considered a
ConnectionStrin gSettings but not a 'string'. Can I still pass a
ConnectionStrin g Setting when using DB calls as a string? (Of course, I
realize that DB connections are now written differently in 2.0 so maybe
that'll make sense when I tackle that next...)

-Darrel

[DHLennon]

try something like this when you first get your connectionstrin g from your
web.config

Dim connectionStrin gs As _
ConnectionStrin gSettingsCollec tion = _
ConfigurationMa nager.Connectio nStrings

Dim myConnString As String =
connectionStrin gs("yourconnect ionstringname") .ConnectionStri ng
then pass myConnString to whatever subs or functions you need

hope that makes sense
"Darrel" wrote:

You're not obligated to use the tool. If you add your own configuration
elements, the wizard will pick them up the next time you run it.

Here are some examples and links that should get you going:

Thanks, Ken! That was simple once I knew. You'd think that if VS.net can
tell you something is deprecated, it could also give you a hit as to what to
replace it with ;o)

I noticed that my DB connection string is now considered a
ConnectionStrin gSettings but not a 'string'. Can I still pass a
ConnectionStrin g Setting when using DB calls as a string? (Of course, I
realize that DB connections are now written differently in 2.0 so maybe
that'll make sense when I tackle that next...)

-Darrel

[Erik Funkenbusch]

On Wed, 12 Apr 2006 08:27:57 -0500, Darrel wrote:

Thanks, Ken! That was simple once I knew. You'd think that if VS.net can
tell you something is deprecated, it could also give you a hit as to what to
replace it with ;o)
Normally you would use the wizard to create the connections string. When
you drop a SqlDataSource onto your form, you can then click the wizards and
it will create the string for you.
I noticed that my DB connection string is now considered a
ConnectionStrin gSettings but not a 'string'. Can I still pass a
ConnectionStrin g Setting when using DB calls as a string? (Of course, I
realize that DB connections are now written differently in 2.0 so maybe
that'll make sense when I tackle that next...)

..ToString() is your friend.