"Tim Thomas" <tim@broadbanned.net> wrote in message
news:c8b81f27.0310191934.2151e0fa@posting.google.com...
> Hello,
> I'm new to VS.NET and am developing an ASP.NET web application. it
> uses a SQL server 2000 DB. I have a local environment set up, and
> once the app has been developed locally i will need to upload it to
> the live server.
>
> My question is: What is the best way to develop so that when i am
> ready to upload to the live server I only need to change the DB
> connection string once.
>
> I have set up a DB connection in VS and when i drop it onto pages it
> creates a sqlconnection string in the code behind file.
> when i drag and drop a db table or stored procedure onto the designer
> surface it also creates the connection in the code behind file for me.
>
> how can i easily change all the connections from server=localhost to
> server=999.99.99.99 ??
>
> i set up a connection string in the web.config file (and can later
> easily change this for the live server) but can't see how to use that
> with visual studios drag and drop features.
>
> I hope someone can see my issue and help. any replys pointing me in
> the right direction would be greatly appreciated.
>
> Thanks
> Tim

"Tim Thomas" <tim@broadbanned.net> wrote in message
news:c8b81f27.0310191934.2151e0fa@posting.google.com...
> Hello,
> I'm new to VS.NET and am developing an ASP.NET web application. it
> uses a SQL server 2000 DB. I have a local environment set up, and
> once the app has been developed locally i will need to upload it to
> the live server.
>
> My question is: What is the best way to develop so that when i am
> ready to upload to the live server I only need to change the DB
> connection string once.
>
> I have set up a DB connection in VS and when i drop it onto pages it
> creates a sqlconnection string in the code behind file.
> when i drag and drop a db table or stored procedure onto the designer
> surface it also creates the connection in the code behind file for me.
>
> how can i easily change all the connections from server=localhost to
> server=999.99.99.99 ??
>
> i set up a connection string in the web.config file (and can later
> easily change this for the live server) but can't see how to use that
> with visual studios drag and drop features.
>
> I hope someone can see my issue and help. any replys pointing me in
> the right direction would be greatly appreciated.
>
> Thanks
> Tim