Much like
Console.WriteLine
, the
SqlParameter
constructor is overloaded, and the first argument to all overloads is the name of the parameter, followed by additional arguments as needed to specify its type and value. So, you dimension your
SqlParameter
array, and fill it with a new
SqlParameter
object for each query parameter. Although all are of a type (
SqlParameter
), each instance is more like a
NameValueCollection
item, and you can mix and match types as needed.
For additional info, please see
https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlparameter(v=vs.110).aspx[
^]