Multiple insert.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

greetings, i'm doing a multiple insert into the db through a store proc. i'm
very sure the sp has nothing wrong. below are my implementation code and
error msg. thanks in advance for the help

objCmd.Connection = objConn
objCmd.CommandType = CommandType.StoredProcedure
objCmd.CommandText = "pr_AUDIT_UPLOAD_UpdateStkCntAud"

With objds.Tables(0)
For intx = 0 To .Rows.Count - 1
objCmd.Parameters.Add("@InsId", SqlDbType.BigInt).Value
= .Rows(intx).Item("Instance#")
objCmd.Parameters.Add("@WHNM", SqlDbType.VarChar,
20).Value = .Rows(intx).Item("WH_NM")
objCmd.Parameters.Add("@SCType", SqlDbType.VarChar,
20).Value = cboAuditRpt.SelectedItem.Value.Trim
objCmd.Parameters.Add("@ProdCode", SqlDbType.VarChar,
20).Value = .Rows(intx).Item("Prod_Cd")
objCmd.ExecuteNonQuery()
Next
End With

objConn.Close()


System.Data.SqlClient.SqlException: Procedure or function
pr_AUDIT_UPLOAD_UpdateStkCntAud has too many arguments specified.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
 
After finishing the first row try clearing the parameters collection of the
command object using command.parameters.clear()

Hope this helps
Shailesh
MCSD .NET
 
You keep adding parameters over and over again...call
objCommand.Parameters.Clear() after the ExecuteNonQuery() Although there
are more efficient ways to do it, it should work.

Karl
 
Back
Top