System.Data.SqlClient Namespace   SqlParameterCollection Class

Removes a parameter from the collection.

1. Removes the SqlParameter at the specified index from the collection.

2. Removes the SqlParameter with the given name from the collection.

The following example first uses the Contains property to find an SqlParameter with a given ParameterName within the Parameters collection of a specifed SqlCommand object. If the parameter exists, the example removes it.

NOTE: This example uses one of the overloaded versions of RemoveAt. For other examples that may be available, see the individual overload topics.

public void SearchSqlParams ( SqlCommand myCmd ) {
   SqlParameterCollection myParams = myCmd.Parameters;
   if ( myParams.Contains ( "@Description" ) )
      myCmd.Parameters.RemoveAt ( "@Description" );

}

Public Sub SearchSqlParams ( ByVal myCmd As SqlCommand )
   Dim myParams As SqlParameterCollection = myCmd.Parameters
   If myParams.Contains ( "@Description" ) Then
      myCmd.Parameters.RemoveAt ( "@Description" );
   End If
End Sub

SqlParameterCollection Members