DataTableCollection.IndexOf Method (DataTable)

 

Gets the index of the specified DataTable object.

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

Public Function IndexOf (
	table As DataTable
) As Integer

Parameters

table
Type: System.Data.DataTable

The DataTable to search for.

Return Value

Type: System.Int32

The zero-based index of the table, or -1 if the table is not found in the collection.

Use the IndexOf method to determine the exact index of a given table.

Before calling IndexOf, you can test for the existence of a table (specified by either index or name) by using the Contains method.

The following example returns the index of each table in the DataTableCollection.

Private Sub GetIndexes()
    ' Get the DataSet of a DataGrid.
    Dim thisDataSet As DataSet = CType(DataGrid1.DataSource, DataSet)

    ' Get the DataTableCollection through the Tables property.
    Dim tables As DataTableCollection = thisDataSet.Tables
    Dim table As DataTable

    ' Get the index of each table in the collection.
    For Each table In tables
       System.Diagnostics.Debug.WriteLine(tables.IndexOf(table))
    Next
End Sub

.NET Framework
Available since 1.1
Return to top
Show: