A collection of SqlParameter objects representing the set of parameters for a stored procedure or parameterized query (and set through the SqlCommand.Parameters property). This class also provides an overloaded Add( ) method that allows you to create and add a SqlParameter object to the collection in one step.

public sealed class SqlParameterCollection : MarshalByRefObject , 
     System.Data.IDataParameterCollection, IList, ICollection, IEnumerable {
// Public Instance Properties
   public int Count{get; }                                     // implements ICollection
   public SqlParameter this[string parameter]{set; get; } 
   public SqlParameter this[int index]{set; get; } 
// Public Instance Methods
   public int Add( object value);              // implements IList
   public SqlParameter Add( SqlParameter value);  
   public SqlParameter Add(string parameterName, object value);
   public SqlParameter Add(string parameterName, System.Data.SqlDbType sqlDbType);
   public SqlParameter Add(string parameterName, System.Data.SqlDbType sqlDbType, int size); 
   public SqlParameter Add(string parameterName,  System.Data.SqlDbType sqlDbType, int size, string sourceColumn);
   public void Clear(  );                                        // implements IList
   public bool Contains( object value);              // implements IList
   public bool Contains( string value);             // implements System.Data.IDataParameterCollection
   public void CopyTo( Array array, int index);                // implements ICollection
   public IEnumerator GetEnumerator(  );                         // implements IEnumerable
   public int IndexOf( object value);                 // implements IList
   public int IndexOf( string parameterName);           // implements System.Data.IDataParameterCollection
   public void Insert( int index, object value);               // implements IList
   public void Remove( object value);                 // implements IList
   public void RemoveAt( int index);                   // implements IList
   public void RemoveAt( string parameterName);        // implements System.Data.IDataParameterCollection
}

Hierarchy

System.Object System.MarshalByRefObject SqlParameterCollection(System.Data.IDataParameterCollection, System.Collections.IList , System.Collections.ICollection , System.Collections.IEnumerable)

Returned By

SqlCommand.Parameters