Where to store connection info ?

[Rob]

Where is the best place to store database connection info in a vb.net
program ? I do not want to "hard-code" a database name into my program.
Where could I store and retrieve that information ? Also, could you point
in the the right direction as to how one might do it ?

Thanks

 

[Cor Ligthert]

Rob,

The nice thing from (the first used) connectionstring is that you cannot
store it in a database.

Therefore you have the choise from an XML file, and than make simple a
dataset by hand or the registry (and than it has to be typed the first time
in)

I hope this helps,

Cor

 

[Herfried K. Wagner [MVP]]

Where is the best place to store database connection info in a vb.net
program ? I do not want to "hard-code" a database name into my program.
Where could I store and retrieve that information ? Also, could you
point in the the right direction as to how one might do it ?

..NET Framework Developer's Guide -- Configuration Files
<URL:http://msdn.microsoft.com/library/en-us/cpguide/html/cpconconfigurationfiles.asp>

 

[Rob]

If you store it in an xml file, is there an easy way to get it out ?
Thanks

 

[Cor Ligthert]

Rob,

Creating a dataset, directly typed in this message so watch typos or
whatever,
\\\
dim ds as new dataset
dim dt as new datatable
ds.tables.add(dt)
dt.columns.add()
dt.loaddatarow(new object() {"myconnectionstring"},true)
ds.writexml("myfilepath")
///
Reading it back
\\\
ds.readxml("myfilepath")
myconnectionstring = ds.tables(0).rows(0)(0).tostring
///

That is all.

I hope this helps,

Cor

 

[DraguVaso]

Use an app.config file.
To read it: strConn =
System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString
")

More info:
http://msdn.microsoft.com/library/d...riintroductiontoapplicationsettingstorage.asp