DataTableCollection.Item Property

System.Data Namespace DataTableCollection Class

Returns a specified table from the collection.

1. Returns the DataTable with the specified name.

[ VB ] Overloads Public Default ReadOnly Property Item ( String ) As DataTable

[ C# ] public DataTable this [ string ] {get;}

[ C++ ] public: __property DataTable* get_Item ( String* );

[ JScript ] DataTableCollection.Item ( String )

2. Returns the DataTable at the specified index.

[ VB ] Overloads Public Default ReadOnly Property Item ( Integer ) As DataTable

[ C# ] public DataTable this [ int ] {get;}

[ C++ ] public: __property DataTable* get_Item ( int );

[ JScript ] DataTableCollection.Item ( int )

The following example retrieves a single table by name from a DataTableCollection.

NOTE: This example uses one of the overloaded versions of Item. For other examples that may be available, see the individual overload topics.

private void GetTableByName ( DataSet ds ) {
   // get a specific table by name.
   DataTable tbl = ds.Tables [ "Suppliers" ];
   Response.Write ( tbl.TableName );
}

Private Sub GetTableByName ( ByVal ds As DataSet )
   ' get a specific table by name.
   Dim tbl As DataTable = ds.Tables ( "Suppliers" )
   Response.Write ( tbl.TableName )
End Sub

DataTableCollection Members

Home Getting Started Web Forms Web Applications ADO.NET ASP/ADO Back to Basics

DataTableCollection.Item Property

Overload List

Example

See Also