You should place the connection string in the web.config file, then read that value whenyou run the app.
>Using .Net2005, how would this best be handled. In my webforms, I have a isProduction property set to either true or false. While false, my webforms use the development SQL Server database etc... Before I publish my Asp.Net web app, I change the property to true so that the production SQL Server databases are used etc...
>
>Is there a better way to do this? A more global way?
>
>Thanks,
>
>Jerry
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer