Simon Mourier's Blog - adding sqlparameter without name

.net
sql
vb6-vba

adding sqlparameter without name

Aug 2, 2016 See the question and my original answer on StackOverflow

Just reset the name to nothing (null) once the parameter has been added, something like this:

    For i = 0 To UBound(Parametros)
        Param = New SqlParameter("str", Parametros(i))
        cmd.Parameters.Add(Param)
        Param.ParameterName = Nothing
    Next