System.Data.OleDb Namespace OleDbParameterCollection Class
Returns the OleDbParameter with the specified name.
OleDbParameter variable = OleDbParameterCollection.Item [ parameterName ];
... or ...
OleDbParameter variable = OleDbParameterCollection [ parameterName ];
dim variable as OleDbParameter = OleDbParameterCollection.Item ( parameterName )
... or ...
dim variable as OleDbParameter = OleDbParameterCollection ( parameterName )
variable : OleDbParameter = OleDbParameterCollection.Item ( parameterName );
... or ...
variable : OleDbParameter = OleDbParameterCollection ( parameterName ); |
| |
C# |
VB |
JScript |
- parameterName
- The name of the parameter to retrieve.
The OleDbParameter with the specified name, or a null reference if the parameter is not found.
IDataParameterCollection.Item
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 displays the index of the parameter; otherwise, the example displays an error.
NOTE: This example uses one of the overloaded versions of the Item property ( OleDbParameterCollection indexer ). For other examples that may be available, see the individual overload topics.
public void SearchOleDbParams ( OleDbCommand myCmd ) {
OleDbParameterCollection myParams = myCmd.Parameters;
if ( myParams.Contains ( "Model" ) )
MessageBox.Show ( "Name: " + myParams [ "Model" ].ToString ( ) +
"Index: " + myParams.IndexOf ( "Model" ).ToString ( ) );
else
MessageBox.Show ( "Sorry, no such parameter found in the collection" );
}
Public Sub SearchOleDbParams ( ByVal myCmd As OleDbCommand )
Dim myParams As OleDbParameterCollection = myCmd.Parameters
If myParams.Contains ( "Model" ) Then
MessageBox.Show ( "Name: " & myParams ( "Model" ).ToString ( ) & _
"Index: " & myParams.IndexOf ( "Model" ).ToString ( ) )
Else
MessageBox.Show ( "Sorry, no such parameter found in the collection" )
End If
End Sub |
| |
C# |
VB |
OleDbParameterCollection Members OleDbParameterCollection.Item Overload List
