System.Data.OleDb Namespace   OleDbParameterCollection Class

Removes the OleDbParameter with the given name from the collection.

[ VB ]
Overloads Public Sub RemoveAt ( _
   ByVal parameterName As String _
)

[ C# ]
void RemoveAt (
   string parameterName
);

[ C++ ]
public: void RemoveAt (
   String* parameterName
);

[ JScript ]
public function RemoveAt (
   parameterName : String
);

parameterName

the name of the parameter to retrieve.

IDataParameterCollection.RemoveAt

The following example first uses the Contains property to find an OleDbParameter with a given ParameterName 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 ( "Description" ) )
      myCmd.Parameters.RemoveAt ( "Description" );

}

Public Sub SearchOleDbParams ( ByVal myCmd As OleDbCommand )
   Dim myParams As OleDbParameterCollection = myCmd.Parameters
   If myParams.Contains ( "Description" ) Then
      myCmd.Parameters.RemoveAt ( "Description" );
   End If
End Sub

OleDbParameterCollection Members   OleDbParameterCollection.RemoveAt Overload List