I am trying to override the default connection string in a table adapter with a string that gets built using the connectionstringbuilder
SqlConnection c = ConnStrBuilder.BuildConnection(orgid);
tvEventLocationsPlusNamesTableAdapter tvELNByEventAdapt = new tvEventLocationsPlusNamesTableAdapter();
tvELNByEventAdapt.Connection = c;
This little snippet is what my current code is but it returns an error because the tvELNByEventAdapt doesnt contain a definition for 'Connection'.
What is the correct way for me to override the default connection string for the table adapter so that its using the correct connection string?