Parameters.Add() loop [RESOLVED]

[drpcken]

Here's what I've got so far:

I'm creating two parameters in a loop and filling them with a variable. Then after running my ExecuteNonQuery I emtpy the parameters with Parameters.Remove() and start the loop again, filling the parameters with new values, and executing.

Now when I only loop once, it works fine. If the loop occurs more than once, and the Parameters.Remove() takes effect, I get an error:
The SqlParameterCollection only accepts non-null SqlParameter type objects, not String objects.

If I comment out my Parameters.Remove() lines, and only loop once, it works fine. Am I using the correct property of Parameter.Remove() to emtpy or remove these parameters? Like I said, everything works perfectly if I only loop once with one set of values for the Parameters and comment out Parameters.Remove(). It seems to me that its not removing the Parameter correctly and starting the loop over, and adding them again.

Here's my code:

Dim sTeamLeaderID, sCounselorID As Integer
Dim sqlConn As New SqlClient.SqlConnection("server=(local); uid=sa; pwd=;initial catalog=IFPAWEB")
Dim sqlSPteam As New SqlClient.SqlCommand("sp_teamleadercounselor", sqlconn)
 
Dim i As Integer
    
sTeamLeaderID = CounselorsTeamLeaderName.Value
     Try
        sqlConn.Open()
         For i = 0 To CounselorsCounselors.Items.Count - 1
        If CounselorsCounselors.Items(i).Selected Then
                sCounselorID = CounselorsCounselors.Items(i).Value
                    
                   With sqlSPteam
                       .CommandType = CommandType.StoredProcedure
                        
                       .Parameters.Add("@counselorid", Convert.ToInt32(sCounselorID))
               .Parameters.Add("@teamleaderid", sTeamLeaderId)
               .ExecuteNonQuery()
               .Parameters.Remove("@counselorID")
               .Parameters.Remove("@teamleaderid")
                                                                       
                   End With
                        
                 End If                                         
              Next i
     Finally
    SqlConn.Close()
     End Try

Thanks!!

[mar_zim]

why wont u use parameters.clear instead of parameters.remove???

[taxes]

Hi,

You now have two threads with exactly the same question.

[drpcken]

Thank you mar_zim

I tried parameter.clear() and used each parameter as an arguement. Then I realized I only had to write it once with no parameters to clear out each filled parameter

Thanks alot man!!