best way for storing connectionstring

[Maileen]

Hi,

my application use a connectionstring to a database.

I would like to know what is the best solution to store to
connectionstring and to avoid to ask everytime to user to enter it, user
and also password..

thanks a lot,
Maileen

 

[Michel van den Berg]

Dear Maileen,

Have a look at
http://msdn.microsoft.com/msdnmag/issues/03/11/ProtectYourData/default.aspx
However, if you don't need all that security I recommend you storing it in
the app.config or web.config.
You can read values from these files with AppSettingsReader.

Hope I helped you,

Michel van den Berg