System.Data.OleDb Namespace   OleDbParameterCollection Class

Removes the specified OleDbParameter from the collection.

[ VB ]
Public Sub Remove ( _
   ByVal parameter As Object _
)

[ C# ]
void Remove (
   object parameter
);

[ C++ ]
public: void Remove (
   Object* parameter
);

[ JScript ]
public function Remove (
   parameter : Object
);

parameter

The OleDbParameter object to remove from the collection.

IList.Remove

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

public void SearchOleDbParams ( OleDbCommand myCmd ) {
   OleDbParameterCollection myParams = myCmd.Parameters;
   if ( myParams.Contains ( ( Object ) myParam ) )
      myCmd.Parameters.Remove ( ( Object ) myParam );

}

Public Sub SearchOleDbParams ( ByVal myCmd As OleDbCommand )
   Dim myParams As OleDbParameterCollection = myCmd.Parameters
   If myParams.Contains ( CType ( myParam, Object ) ) Then
      myCmd.Parameters.Remove ( CType ( myParam, Object ) );
   End If
End Sub

OleDbParameterCollection Members