How to change database when deploying application

[harry]

I've set my database connection as an Application.Set ting using the
designer.

Since Application.Set tings are read only, how do I change the connection
properties when deploying to another machine ?

Thanks
Harry

[Penelope Dramas]

Perhaps you should put it as User Setting and then build a small form to
allow users to change db settings.
"harry" <[e-mail] wrote in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..

I've set my database connection as an Application.Set ting using the
designer.

Since Application.Set tings are read only, how do I change the connection
properties when deploying to another machine ?

Thanks
Harry

[VJ]

You could also keep it a local xml file or something and read it..

VJ

"harry" <[e-mail] wrote in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..

I've set my database connection as an Application.Set ting using the
designer.

Since Application.Set tings are read only, how do I change the connection
properties when deploying to another machine ?

Thanks
Harry

[harry]

I know what the end users database is called and would prefer to avoid
additional work for user.

I would prefer to set dynamically when loading application.

I guess this is a common scenario and also guess one uses an XML file
deployed with the app.

Having used the designer to set the Connection string, and then built my
DataSet (again using designer) around that connection string I wonder why
the settings are ReadOnly when it's an obvious scenario for many developers.
I guess there's an obvious solution - one that I have yet to find.

Any other suggestions please ?
"Penelope Dramas" <penelopeDOTdra masATpro-transportDOTcom wrote in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..

Perhaps you should put it as User Setting and then build a small form to
allow users to change db settings.
"harry" <[e-mail] wrote in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..

>I've set my database connection as an Application.Set ting using the
designer.

Since Application.Set tings are read only, how do I change the connection
properties when deploying to another machine ?

Thanks
Harry

[harry]

Sure a local XML file would be fine.

I guess I need to change the DataSet.DataSou rce as the program loads, but
not sure how at the moment.

Having already used the designer to create the connection and DataSet, how
do I go about doing this?

Would you know of a URL showing how do do this?

This must be a common scenario.
"VJ" <no***********@ yahoo.comwrote in message
news:ev******** ******@TK2MSFTN GP04.phx.gbl...

You could also keep it a local xml file or something and read it..

VJ

"harry" <[e-mail] wrote in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..

>I've set my database connection as an Application.Set ting using the
designer.

Since Application.Set tings are read only, how do I change the connection
properties when deploying to another machine ?

Thanks
Harry

[Spam Catcher]

"harry" <[e-mail] wrote in news:#oexeMAbHH A.1388
@TK2MSFTNGP05.p hx.gbl:

Since Application.Set tings are read only, how do I change the connection
properties when deploying to another machine ?

I wish VS.NET had a way to inject deployment App.config keys... that would
solve this problem right? :-)

[=?Utf-8?B?Vm9sa2VyUw==?=]

Hi Harry,

data in the app.config isn't readonly at all! It can be accessed through the
configurationma nager-class (but not by my.settings, that's right). Below you
find code I use to set the connection-string at runtime. Be aware of the
fact, that you can use more than one connectionstrin g in your config, hence
the SectName.

Public Shared Sub SetConnectStrin g(ByVal SectName As String, ByVal
ConnectString As String, ByVal encrypt As Boolean)
Dim settings As New ConnectionStrin gSettings
settings.Name = SectName
settings.Connec tionString = ConnectString

Dim config As Configuration
config =
ConfigurationMa nager.OpenExeCo nfiguration(Con figurationUserL evel.None)
config.Connecti onStrings.Conne ctionStrings.Re move(SectName)
config.Connecti onStrings.Conne ctionStrings.Ad d(settings)
If encrypt Then

config.Connecti onStrings.Secti onInformation.P rotectSection(N othing)
End If
config.Save()
End Sub
HTH

Volker

"harry" wrote:

I've set my database connection as an Application.Set ting using the
designer.

Since Application.Set tings are read only, how do I change the connection
properties when deploying to another machine ?

Thanks
Harry

[harry]

Great.

Thanks for your help and saving me a heap of time.

Regards
Harry
"VolkerS" <Vo*****@discus sions.microsoft .comwrote in message
news:B3******** *************** ***********@mic rosoft.com...

Hi Harry,

data in the app.config isn't readonly at all! It can be accessed through
the
configurationma nager-class (but not by my.settings, that's right). Below
you
find code I use to set the connection-string at runtime. Be aware of the
fact, that you can use more than one connectionstrin g in your config,
hence
the SectName.

Public Shared Sub SetConnectStrin g(ByVal SectName As String, ByVal
ConnectString As String, ByVal encrypt As Boolean)
Dim settings As New ConnectionStrin gSettings
settings.Name = SectName
settings.Connec tionString = ConnectString

Dim config As Configuration
config =
ConfigurationMa nager.OpenExeCo nfiguration(Con figurationUserL evel.None)
config.Connecti onStrings.Conne ctionStrings.Re move(SectName)
config.Connecti onStrings.Conne ctionStrings.Ad d(settings)
If encrypt Then

config.Connecti onStrings.Secti onInformation.P rotectSection(N othing)
End If
config.Save()
End Sub
HTH

Volker

"harry" wrote:

>I've set my database connection as an Application.Set ting using the
designer.

Since Application.Set tings are read only, how do I change the connection
properties when deploying to another machine ?

Thanks
Harry