Avoid connecting to a database through a connection string

[John Kh]

Hello, How can I avoid connecting to a database through a connection string? Because everytime I change the database location I should set a new connection string with the new location. Is there a way to avoid this and save the database within the project itself? And keep the connection there no matter where I install the database? Can I still select, update, delete ... from the database? John,

[coolguy0070]

you can set connection string in ur web config file

[Lost User]

If only this was for ASP.NET...

[Lost User]

John, Maybe you should check out SQL Server Compact Edition[^]. "SQL Server Compact is a free, easy-to-use embedded database engine that lets developers build robust Windows Desktop and mobile applications that run on all Windows platforms including Windows XP, Vista, Pocket PC, and Smartphone." You can also use SQL Server Express Edition (on localhost) and use a connection string that attaches the database each time you want to connect:

Driver={SQL Native Client};Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;

[rprateek]

Check the following link out it would be helpful for you: Secure Connection and Easy transaction Handling^ In the above link the connection string is read through DBConfig.ini and when you change the database location just change it in the ini file and would work perfectly for your web or desktop applications.

Blog for Programmers http://www.rprateek.blogspot.com

[Jon_Boy]

I'd do something different from the other suggestions listed. I'd create a UDL file within your application directory. Your program will read the UDL for the connect string. If you run your app on another computer/domain, you can easily update the connect string through the UDL's GUI (eliminates the possibility of manually entering in the connectstring in a file and making a mistake). Right click on your desktop and create a .txt file. Rename the file to something like test.udl. Double click it and you'll see what I'm getting at. There's numerous articles on how to read a udl if you need help. Cheers!

Any suggestions, ideas, or 'constructive criticism' are always welcome.

[AlexeiXX3]

Store your connection string in the application settings and set all connection objects to the application setting To store an app setting: Right click your project > properties > settings > add your connection string

Alexei Rodriguez