Export (0) Print
Expand All

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
)
public int Find (
	Object[] key
)
public function Find (
	key : Object[]
) : int
Not applicable.

Parameters

key

An array of values, typed as Object.

Return Value

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 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

Windows 98, Windows Server 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0, 1.1, 1.0

.NET Compact Framework

Supported in: 2.0, 1.0

XNA Framework

Supported in: 1.0

Community Additions

ADD
Show:
© 2014 Microsoft