I will be using the table adapter to fill my datasets from my oracle database, but what would be the proper way to add the userid and password to the connection string. That is, at design time, I've set the connection string in my datasets to everything it needs except for the userid and password. Then I have a dialog box which prompts the user for userid and password. Then I can simply append them to the connection string when I code any connection object.

But what if I am using an windows control where it uses the default connection string in the dataset.designer.vb file. Should I simply modify that objects connection property just before using it or would it be better to modify the default connection string somehow.

You can modify the objects connection string before the objects are used.