Remove plain-text password from app.config connection string

[wolf99]

Hi folks

Some time ago I set up a DB connection in a vb.net windows forms project in VS 2010. I think I remember some pop--up asking me about storage of the password but I didnt matter at the time so I clicked cancel/no.

Now I have the password stored in plain-text in the app.config file and now it does matter . I took a quick look on Google but it seemed like their was an avalanche of info on hashing, salting, etc (like making breakfast). I just want to get back to that wizard that wanted to do the standard approach for me.

Have I mis-remembered, is there no such wizard/option? If there is where do I find it in VS?

Thanks

[dday9]

What you're referring to is the data source wizard. Try this approach:

Step 1a. Press Alt + Shift + D to bring up the Data Sources window
Step 1b. Or in the menu strip, click on data -> Show Data Sources
Step 2. Click on Add New Data Source...
Step 3. Follow the wizard on adding a new Database

[jmcilhinney]

You can encrypt part of the config file to keep such sensitive data safe. Follow the CodeBank link in my signature and check out my thread on Protected Configuration for more info.