System.Data.SqlClient Namespace SqlParameterCollection Class
Checks whether a parameter is in the collection.
1. Checks whether a given SqlParameter object is in the collection.
2. Checks whether an SqlParameter with the specified name is in the collection.
The following example shows use of 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 displays the index of the parameter; otherwise, the example displays an error.
NOTE: This example uses one of the overloaded versions of the Contains method. For other examples that may be available, see the individual overload topics.
public void SearchSqlParams ( SqlCommand myCmd ) {
SqlParameterCollection 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 SearchSqlParams ( ByVal myCmd As SqlCommand )
Dim myParams As SqlParameterCollection = 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 |
SqlParameterCollection Members
