Consider this code...



If a = True Then

'add sqlparameter to parameter array

End If



If b = True Then

'add sqlparameter to parameter array

End If



If c = True Then

'add sqlparameter to parameter array

End If



Each time this code runs the parameter array could change sizes... The first time it could contain only one parameter... the second time it runs it could contain three parameters.



How do i define the parameter array when i dont know how many dimensions I'll need, and how do I add parameters to the array?

The reason I was asking this question is because I am using the Data Access Application Block (DAAB) to execute a stored procedure and it accepts sqlparameters as a parameter array.



If i understand what you said correctly then this is how I would want my example to look...



Dim loParms As New System.Collections.Generic.List(Of SqlParameter)



loParms.Add(New SqlParameter("@Param1", 1))

loParms.Add(New SqlParameter("@Param2", 2))



SqlHelper.ExecuteNonQuery(CONNECTION_STRING, CommandType.StoredProcedure, "StoredProcedureName", loParms)



FYI, SqlHelper is a method in the DAAB.

If it expects an array then you need to make one simple change:

SqlHelper.ExecuteNonQuery(CONNECTION_STRING, CommandType.StoredProcedure, "StoredProcedureName", loParms.ToArray())