Error Stored Procedure Parameters

Hi i'll get the following error





The SqlParameter with ParameterName 'xxxxx' is already contained by another SqlParameterCollection.





I'am trying to create an dataset in which data of the different connectionpoints are separated into different tables. Herefor i'm using an stored procedure.





Below you'll find part of the main function and the full function which will execute the stored procedure.





kind regards








main function





Dim Parameters As SqlParameter() = { _


New SqlParameter("@ConnectionPointID", SqlDbType.NVarChar, 255)}








For x = 0 To myds.Tables("ConnectionPoints").Rows.Count - 1


connectionpointID = myds.Tables("connectionpoints").Rows(x).Item("Eancode")


Parameters(0).Value = connectionpointID


mydb.doStoredProcedure("SP_EDS_Dyomes_XML", Parameters,connectionpointID.ToString, myds)


Next











Public Overloads Function doStoredProcedure( _


ByRef Mycommand As SqlCommand, _


ByRef myds As DataSet, _


ByVal Table As String)








Dim myda As New SqlDataAdapter





Mycommand.CommandTimeout = 180


If Mycommand.Connection Is Nothing Then


Dim mydb As New Database


Mycommand.Connection = mydb.generateconnection


End If


If Mycommand.Connection.State = ConnectionState.Closed Then


Mycommand.Connection.Open()


End If


CheckParameters(Mycommand)


myda.SelectCommand = Mycommand





Try


myda.Fill(myds, Table)


Catch ex As Exception


Debug.Write(ex.Message)


End Try


myda.Dispose()


Mycommand.Dispose()





End Function