DataView.Find Method (Object) (System.Data)

Switch View

Find Method (Object)

Collapse All

Language Filter

This page is specific to

Microsoft Visual Studio 2008/.NET Framework 3.5

Other versions are also available for the following:

.NET Framework Class Library

DataView..::.Find Method (Object)

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

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

Syntax

Visual Basic (Declaration)

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

Visual Basic (Usage)

Dim instance As DataView
Dim key As Object
Dim returnValue As Integer

returnValue = instance.Find(key)

public int Find(
    Object key
)

Visual C++

public:
int Find(
    Object^ key
)

JScript

public function Find(
    key : Object
) : int

Parameters

key: Type: System..::.Object
The object to search for.

Return Value

Type: System..::.Int32
The index of the row in the DataView that contains the sort key value specified; otherwise -1 if the sort key value does not exist.

Examples

The following Visual Basic example uses the Find method to return the index of the row that contains the value in the sort key column that you want.

Visual Basic

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

    ' Find the customer named "DUMON" in the primary key column
    Dim i As Integer = view.Find("DUMON")
    Console.WriteLine(view(i))
End Sub

Platforms

Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98, Windows CE, Windows Mobile for Smartphone, Windows Mobile for Pocket PC, Xbox 360, Zune

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Version Information

.NET Framework

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

.NET Compact Framework

Supported in: 3.5, 2.0, 1.0

XNA Framework

Supported in: 3.0, 2.0, 1.0

Reference

DataView Class

DataView Members

Find Overload

System.Data Namespace

Delete

Other Resources

DataSets, DataTables, and DataViews (ADO.NET)