How to move this line to web.config?

[Shapper]

Hello,

I have a dataset in an ASP.NET/VB web page:

Function dsNews() As System.Data.Dat aSet
Dim connectionStrin g As String = "Provider=Micro soft.Jet.OLEDB. 4.0;
Ole DB Services=-4; Data Source=C:\Datab ase\myDatabase. mdb"
Dim dbConnection As System.Data.IDb Connection = New
System.Data.Ole Db.OleDbConnect ion(connectionS tring)
Dim queryString As String = "SELECT [t_news].* FROM [t_news]"
Dim dbCommand As System.Data.IDb Command = New
System.Data.Ole Db.OleDbCommand
dbCommand.Comma ndText = queryString
dbCommand.Conne ction = dbConnection
Dim dataAdapter As System.Data.IDb DataAdapter = New
System.Data.Ole Db.OleDbDataAda pter
dataAdapter.Sel ectCommand = dbCommand
Dim dataSet As System.Data.Dat aSet = New System.Data.Dat aSet
dataAdapter.Fil l(dataSet)
Return dataSet
End Function

Shouldn't I move the connection,
connectionStrin g As String = "Provider=Micro soft.Jet.OLEDB. 4.0; Ole DB
Services=-4; Data Source=C:\Datab ase\myDatabase. mdb"

to my Web.config file?

Can someone tell me how can I do this?

Thank You,
Miguel

[Lars-Erik Aabech]

Hi!

There are several recommended ways to do this. One of them (at least the
initial step towards a better workday) is to put connectionstrin g info in
web.config. You can do this by adding the element <appSettings> to your
web.config between the <configuratio n> and <system.web> elements. Inside the
appSettings element you can define as many keys with string values as you
want and then access these with the
System.Configur ation.Configura tionSettings class later.
Here's an example:

In your web.config:

<configuratio n>
<appSettings>
<add key="connStr" value="Data Source=xx...... "/> <!-- Full
connection string -->
</appSettings>
<system.web>
.....

In your code:

string connStr =
System.Configur ation.Configura tionSettings.Ap pSettings.Get(" connStr");

Et voilà :) You've made you'r app configurable..

HTH,
Lars-Erik

"Shapper" <mdmoura*NOSPAM *@gmail.*DELETE 2SEND*com> wrote in message
news:eT******** *****@TK2MSFTNG P12.phx.gbl...

Hello,

I have a dataset in an ASP.NET/VB web page:

Function dsNews() As System.Data.Dat aSet
Dim connectionStrin g As String = "Provider=Micro soft.Jet.OLEDB. 4.0; Ole
DB Services=-4; Data Source=C:\Datab ase\myDatabase. mdb"
Dim dbConnection As System.Data.IDb Connection = New
System.Data.Ole Db.OleDbConnect ion(connectionS tring)
Dim queryString As String = "SELECT [t_news].* FROM [t_news]"
Dim dbCommand As System.Data.IDb Command = New
System.Data.Ole Db.OleDbCommand
dbCommand.Comma ndText = queryString
dbCommand.Conne ction = dbConnection
Dim dataAdapter As System.Data.IDb DataAdapter = New
System.Data.Ole Db.OleDbDataAda pter
dataAdapter.Sel ectCommand = dbCommand
Dim dataSet As System.Data.Dat aSet = New System.Data.Dat aSet
dataAdapter.Fil l(dataSet)
Return dataSet
End Function

Shouldn't I move the connection,
connectionStrin g As String = "Provider=Micro soft.Jet.OLEDB. 4.0; Ole DB
Services=-4; Data Source=C:\Datab ase\myDatabase. mdb"

to my Web.config file?

Can someone tell me how can I do this?

Thank You,
Miguel

[Shapper]

Thanks Lars.

"Lars-Erik Aabech" <la******@newsg roup.nospam> wrote in message
news:la******@n ewsgroup.nospam :

Hi!

There are several recommended ways to do this. One of them (at least the
initial step towards a better workday) is to put connectionstrin g info in
web.config. You can do this by adding the element <appSettings> to your
web.config between the <configuratio n> and <system.web> elements. Inside the
appSettings element you can define as many keys with string values as you
want and then access these with the
System.Configur ation.Configura tionSettings class later.
Here's an example:

In your web.config:

<configuratio n>
<appSettings>
<add key="connStr" value="Data Source=xx...... "/> <!-- Full
connection string -->
</appSettings>
<system.web>
.....

In your code:

string connStr =
System.Configur ation.Configura tionSettings.Ap pSettings.Get(" connStr");

Et voilà :) You've made you'r app configurable..

HTH,
Lars-Erik

"Shapper" <mdmoura*NOSPAM *@gmail.*DELETE 2SEND*com> wrote in message
news:eT******** *****@TK2MSFTNG P12.phx.gbl...

Hello,

I have a dataset in an ASP.NET/VB web page:

Function dsNews() As System.Data.Dat aSet
Dim connectionStrin g As String = "Provider=Micro soft.Jet.OLEDB. 4.0; Ole
DB Services=-4; Data Source=C:\Datab ase\myDatabase. mdb"
Dim dbConnection As System.Data.IDb Connection = New
System.Data.Ole Db.OleDbConnect ion(connectionS tring)
Dim queryString As String = "SELECT [t_news].* FROM [t_news]"
Dim dbCommand As System.Data.IDb Command = New
System.Data.Ole Db.OleDbCommand
dbCommand.Comma ndText = queryString
dbCommand.Conne ction = dbConnection
Dim dataAdapter As System.Data.IDb DataAdapter = New
System.Data.Ole Db.OleDbDataAda pter
dataAdapter.Sel ectCommand = dbCommand
Dim dataSet As System.Data.Dat aSet = New System.Data.Dat aSet
dataAdapter.Fil l(dataSet)
Return dataSet
End Function

Shouldn't I move the connection,
connectionStrin g As String = "Provider=Micro soft.Jet.OLEDB. 4.0; Ole DB
Services=-4; Data Source=C:\Datab ase\myDatabase. mdb"

to my Web.config file?

Can someone tell me how can I do this?

Thank You,
Miguel