System.Data.SqlClient Namespace   SqlParameterCollection Class

Removes the SqlParameter 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 SqlParameter with a given ParameterName within the Parameters collection of a specifed SqlCommand object. If the parameter exists, the example removes it.

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   SqlParameterCollection.RemoveAt Overload List