I have a windows application written in vb.net 2005 / ADO.net v2.
I have a couple of forms in this application in which I have used the designer to add SqlConnection and SqlDataAdapter.
Is there any way I can change the Connection String by code, rather than sticking to the built in connection string that was generated while creating the SqlConnection and SqlDataAdapter from the designer.
The reason for that is because this application is used by many users, and each user has a different connection string
It appears to me that I have to create the whole thing in code from scratch, but bearing in mind that the designer has automatically generated the 'Select', 'Insert', 'Delete', & 'Update' commands for the DataAdapter, is there an easy way to create both the SqlConnection and SqlDataAdapter, without going through the hassle of writing code for the 'Select', 'Insert', 'Delete', & 'Update' commands.
Your suggestions are well appreciated.
I need to place a code here to force the following
DataAdapters to use a Connection String different from
the one that was generated when I first created those adapters