DB2ParameterCollection.Contains (String) Method

Syntax

[Visual Basic]
NotOverridable Overloads Public Function Contains( _
   ByVal value As String _
) As Boolean Implements IDataParameterCollection.Contains
[C#]
public bool Contains(
   string value
);
[C++]
public: __sealed bool Contains(
   String* value
);
[JScript]
public function Contains(
   value : String
) : Boolean;

Implements:

IDataParameterCollection.Contains

Parameters

value

The name of the DB2®Parameter object to find.

Return value

true if the collection contains the parameter; otherwise, false.

Example

[Visual Basic, C#] The following example searches for a DB2Parameter with a given DB2Parameter.ParameterName within a DB2ParameterCollection. If the parameter exists, the example displays the name and index of the parameter. If the parameter does not exist, the example displays an error. This example assumes that a DB2ParameterCollection has already been created.

[Visual Basic]
Public Sub SearchDB2Params()
    ' ...
    ' create DB2ParameterCollection myParameters
    ' ...
    If Not myParameters.Contains("Description") Then
        MessageBox.Show("ERROR: no such parameter in the collection")
    Else
        MessageBox.Show("Name: " & myParameters("Description").ToString() & _
                        "Index: " & myParameters.IndexOf("Description").ToString())
    End If
End Sub 'SearchDB2Params

[C#]
public void SearchDB2Params() {
    // ...
    // create DB2ParameterCollection myParameters
    // ...
    if (!myParameters.Contains("Description"))
       MessageBox.Show("ERROR: no such parameter in the collection");
    else
       MessageBox.Show("Name: " + myParameters["Description"].ToString() +
                 "Index: " + myParameters.IndexOf("Description").ToString());
 }