Settings.settings in C# For Connectionstring

Question

I would like to know is there any way to declare a variable in setting.setting file to hold my connection string. then i can read it from there for example:
properties.settings.default.connectionstring

thanks

Any reason the connectionStrings section in the .config file is not good enough? — Oded
– Oded, Commented Sep 2, 2011 at 20:04
Just wanted to find out if it possible. coz it does not accent initialcatalog variable in there. — saiful
– saiful, Commented Sep 3, 2011 at 16:14

Dustin Davis · Accepted Answer · 2011-09-02 20:06:50Z

1

Add the setting in the Settings tab in the properties of your project. Make sure it's User scope, not Application scope or it will be read only. Then access it using Settings.Default.ConnectionString

Just keep in mind that this isn't "secure" if that is your goal. Just makes it easier to change at runtime vs a config file. Note that the settings are actually stored in the config file.

answered Sep 2, 2011 at 20:06

Dustin Davis

14.7k14 gold badges67 silver badges123 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Erik Philips · Accepted Answer · 2011-09-02 20:04:23Z

0

Is there a problem using the recommended (web/app).config to hold connection strings?

How to: Read Connection Strings from the .config File

answered Sep 2, 2011 at 20:04

Erik Philips

54.9k11 gold badges133 silver badges158 bronze badges

Collectives™ on Stack Overflow

Settings.settings in C# For Connectionstring

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related