I'm trying to use the 'Add new datasource' feature in vb.net to create a dataset so I can just drag the dataset onto my form as a datagrid.
The dataset comes from a .accdb database with a password.
I'm wanting to use the wizard because it is much easier to keep things synchronized to each other.
I don't know how to handle the password though as it is generated from a user login and not stored in the application at all.
In the past I've always done this from code.
ie.
passed the password manually to the connection string and created a dataset with an sql statement and set the datagrid.datasource to the dataset.
Anyone know how to handle passwords when using the wizard?