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) connectionstrin g 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]]

"Rob" <rw*****@comcas t.net> schrieb:

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/cpconconfigurat ionfiles.asp>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[Rob]

If you store it in an xml file, is there an easy way to get it out ?
Thanks
"Cor Ligthert" <no************ @planet.nl> wrote in message
news:uu******** ******@TK2MSFTN GP12.phx.gbl...

Rob,

The nice thing from (the first used) connectionstrin g 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

[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(d t)
dt.columns.add( )
dt.loaddatarow( new object() {"myconnections tring"},true)
ds.writexml("my filepath")
///
Reading it back
\\\
ds.readxml("myf ilepath")
myconnectionstr ing = ds.tables(0).ro ws(0)(0).tostri ng
///

That is all.

I hope this helps,

Cor

[DraguVaso]

Use an app.config file.
To read it: strConn =
System.Configur ation.Configura tionSettings.Ap pSettings.Get(" ConnectionStrin g
")

More info:
http://msdn.microsoft.com/library/de...ingstorage.asp


"Rob" <rw*****@comcas t.net> wrote in message
news:--*************** *****@comcast.c om...

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