Hi everybody!

can someone please tell me how I can set different connection strings for different build stages using VS2005?

I want to connect to our 'Dev' database while I'm running in debug, but use our production database when I compile the release version.

Cheers,

Chris

There are two secrets to success in this world:
1. Never tell everything you know

__________________
There are two secrets to success in this world:
1. Never tell everything you know

The debug build configuration is preconfigured to include the "DEBUG" preprocessor symbol in the compile. Therefore you can do this:

#if DEBUG
    strConnectionString = <get dev conn string>;
#else
    strConnectionString = <get production conn string>;
#endif

You can also define your own symbols if you wanted to use other configurations.

-Peter

Thanks Peter.

There are two secrets to success in this world:
1. Never tell everything you know