hey friends i have one query regarding project ...

while creating project on our local computer we give path of our sql server in our code which contains our database, but when we transfer our project to some other computer than we need to make changes in our code again to make it work. Is there any way to eliminate this ?

and when we create exe of our project, will this problem be eliminated ?

Don't put the path into your code, use the Settings (In Visual Studio, select Project the Properties (last item). Then select the Settings tab). The settings are kept in an XML file so when you need to change one for a different system, you can just edit the XML file and not have to recompile your code.

You can read about Settings here.