DataView.Find Method (Object[])

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

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

public int Find(
	Object[] key
)

Parameters

key
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)
    Console.WriteLine(view(i))
End Sub


.NET Framework

Supported in: 4, 3.5, 3.0, 2.0, 1.1, 1.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft