I tried to use the add parameters routine described in chapter 9 page 346
my example is below. The program returns indicating my first parameter is missing, although the parameter count is correct. Is the second parameter overwriting?
Code:
Dim cmd As SqlCommand = New SqlCommand(uspGroupXref, connSql)
cmd.CommandType = CommandType.StoredProcedure
Dim parameter As SqlParameter = Nothing
parameter = New SqlParameter
parameter.ParameterName = "@sBCAPartner"
parameter.SourceColumn = sBCAPartner
cmd.Parameters.Add(parameter)
parameter = New SqlParameter
parameter.ParameterName = "@sLabAcctNbr"
parameter.SourceColumn = sLabAcctNbr
cmd.Parameters.Add(parameter)
cmd.Connection.Open()
Dim myreader As SqlDataReader
Dim returndata As String = ""
myreader = cmd.ExecuteReader(CommandBehavior.CloseConnection)
BuildSqlCommand