Connection to SQL

[shers]

Hi,
I am using VB.NET to create an application with SQL Server as backend. I have read some articles on putting the connection string in a config or xml file so that the database location can be easily changed in future. But I dont know how to go about it.
I also wish to create more than one application that uses the same database. These different applications will be used by more than one user at the same time. How can I go about this? Please help.

Thanks

[srinivas_s]

in your config file under the <configuration> xml tag
you can something like this
<appSettings>
<add key="connString" value="your connection string refer msdn"/>
</appSettings>

In your code import System.Configuration namespace
then access this string ConfigurationSettings.AppSettings["connString"]
and then use to do the database connection