IndexOf Method (String)

Gets the location of the SqlCeParameter in the collection with the specified parameter name.

Namespace:  System.Data.SqlServerCe
Assembly:  System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)


Public Overrides Function IndexOf ( _
    parameterName As String _
) As Integer
Dim instance As SqlCeParameterCollection
Dim parameterName As String
Dim returnValue As Integer

returnValue = instance.IndexOf(parameterName)
public override int IndexOf(
    string parameterName
virtual int IndexOf(
    String^ parameterName
) override
abstract IndexOf : 
        parameterName:string -> int 
override IndexOf : 
        parameterName:string -> int 
public override function IndexOf(
    parameterName : String
) : int


Return Value

Type: System. . :: . .Int32
The location of the SqlCeParameter in the collection.


IDataParameterCollection. . :: . .IndexOf(String)


The following example searches for a SqlCeParameter with a given ParameterName within a SqlCeParameterCollection. If the parameter exists, the example displays the index of the parameter. If the parameter does not exist, the example displays an error. This example assumes that a SqlCeCommand has already been created.

' ...
' create SqlCeCommand cmd
' ...
If Not cmd.Parameters.Contains("Description") Then
    MessageBox.Show("ERROR: no such parameter in the collection")
    MessageBox.Show("match on parameter #" & cmd.Parameters.IndexOf("Description").ToString())
End If
// ...
// create SqlCeCommand cmd
// ...
if (!cmd.Parameters.Contains("Description"))
    MessageBox.Show("ERROR: no such parameter in the collection");
    MessageBox.Show("match on parameter #" +

See Also


SqlCeParameterCollection Class

SqlCeParameterCollection Members

IndexOf Overload

System.Data.SqlServerCe Namespace