Reference to connectionstring in settings

Question

This is for a Windows Application.

In a class I want to referee to my connectionstring called freighthelper which is located in the settings.settings file in my project. How do I do this?

I have tried with this without success.

_connection.ConnectionString = FreightHelper.Properties.Settings.Default.freighthelper;

That's the correct way to do it. What problem are you seeing? Any error message? — Michael Petrotta
– Michael Petrotta, Commented Sep 24, 2010 at 6:06
if that code compiles, then the setting must exist. You should explain more details about "without success": Was the ConnectionString wrong or empty after trying to get it (probably easy to solve)? Or did you just not succeed in connecting to the database (much more possibilities for errors)? — Simon D.
– Simon D., Commented Sep 24, 2010 at 7:01
Sorry, the code was correct but the problem was that I used code for SQL-database instead of OleDb. You got me to realize this, thanks. — hejahv
– hejahv, Commented Sep 24, 2010 at 7:22

GôTô · Accepted Answer · 2010-09-24 06:08:56Z

2

Why do you need to store your connection string in a settings file? It is usually put in the config file and retrieved like this: http://msdn.microsoft.com/en-us/library/ms254494%28VS.80%29.aspx

answered Sep 24, 2010 at 6:08

GôTô

8,0733 gold badges37 silver badges45 bronze badges

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

1 Comment

hejahv Over a year ago

It seams like my connectionstring already is stored in the config file like this.

anishMarokey · Accepted Answer · 2010-09-24 06:07:33Z

0

try this: _connection.ConnectionString=Settings.Default. freighthelper; to read form a setting files.

NOte: connection string better to place in App.confing

E.g:

<connectionStrings>
    <add name="Name" connectionString="Data Source=Instance Name;Integrated Security=True;MultipleActiveResultSets=True;"
      providerName="System.Data.EntityClient" />

answered Sep 24, 2010 at 6:07

anishMarokey

11.4k2 gold badges36 silver badges47 bronze badges

Collectives™ on Stack Overflow

Reference to connectionstring in settings

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related