Feel its weired hardcode database details in web.config, according to my client, web.config automatically direct to the respective server database when deploy asp.net application. i have a custom db installer class which lets the user to keyin database server, db name, username and password when deploy. but how to make this to update web.config??.

Hi,

Probably something to do with the <connectionStrings> region in your web.config...

Hi u can specify ur connection string in web.config, so that u can make any change any time, without recompile ur application. bcoz it is purely XML file.

Add the following section in web.config:

<appsettings>
<add key="ConnectionString" value="server=UrServerName;database=UrDatabaseName ;uid=UserName;pwd=Pasword" />
</appsettings>

Hi anuj and notrosh

yes its exactly connection string , no doubt, but how to update the servername ("UrServerName"), databasename(UrDatabaseName), uid and pwd from the deployment screen(where the user keyin when i deploy my asp.net application) to the connection string which i have given as same as anuj has written ie
<appsettings>
<add key="ConnectionString" value="server=UrServerName;database=UrDatabaseName ;uid=UserName;pwd=Pasword" />
</appsettings>

meaning i dont want to manually change web.config file when i deploy in different server.

in that case
isit possible to keep servername,dbname,uid and pwd as variable and get it from the db installer class(db installer class is a project inside my application solution which interfaces with the websetup project inside my application and generate a user interface screen for user to keyin database infos)?.

or whats the best way to make this possible?

thanks