|
-
Aug 24th, 2004, 12:58 AM
#1
Thread Starter
Fanatic Member
Parameters.Add() loop [RESOLVED]
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:
VB 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!!
Last edited by drpcken; Aug 24th, 2004 at 09:16 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|