class library - connection string with typed datasets

I have a class library project and I've added a typed dataset to the project.  After compiling, everything ran fine in my development environment, but when I moved the assembly to my test server, which is using a different sql server, the connection didn't work.

I discovered that the connection string is hard-coded into the settings file in the class library project.  Thereby, I had to modify the connection string, recompile, deploy.  Then back in my development environment, I  had to reset the connection string for my development sql server, recompile and add the reference to my development  project again.

Please tell me there is an easier way to handle this?  If I have to make changes or add new typed datasets, I'd have to do the same over again.

Is there a way to overcome this?

Thanks for any help.
-Dman100-Software ConsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DhaestCommented:
Is your connectionstring stored into the code or is it stored in a settings.settings, app.config, ... ?
0
DhaestCommented:
Perhaps this article can help you further
How to move a Typed Dataset to its own Project and Namespace - Part 2 - Deployment and ConnectionStrings
http://kmccaa.blogspot.com/2007/07/how-to-move-typed-dataset-to-its-own_11.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.