In attempt to get away from using the DataAdapter Wizard - it's causing problems with the connection the we are using. I need to hand code in the adpaters. I'm looking for a good example of one that is using a stored procedure that needs a parameter or multiple parameters.
Any help would be appreciated.
my connectionstring is using the app.config file (example)
Me.SqlConnection1.ConnectionString = AppSettings.Get("ABRConn")
When using the wizard this string can not be selected and if the connection string in the adpater is changed with the wizard it removes the above code.
thanks in advance.