DataView.Find Method (Object())


The .NET API Reference documentation has a new home. Visit the .NET API Browser on to see the new experience.

Finds a row in the DataView by the specified sort key values.

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

Public Function Find (
	key As Object()
) As Integer


Type: System.Object()

An array of values, typed as Object.

Return Value

Type: System.Int32

The index of the position of the first row in the DataView that matches the sort key values specified; otherwise -1 if there are no matching sort key values.

The following Visual Basic example uses the Find method to return the index of a row that contains specified values in its sort key columns.

Private Sub FindValueInDataView(table As DataTable)
    Dim view As DataView = New DataView(table)
    view.Sort = "Customers"

    ' Find the customer named "John Smith".
    Dim vals(1) As Object
    vals(0)= "John"
    vals(1) = "Smith"
    Dim i As Integer = view.Find(vals)
End Sub

.NET Framework
Available since 1.1
Return to top