dotConnect for MySQL Documentation
Devart.Common Namespace / SelectTableCollection Class
Members Example

In This Topic
    SelectTableCollection Class
    In This Topic
    Represents a collection of tables and subqueries in a SelectStatement object.
    Syntax
    'Declaration
     
    Public NotInheritable Class SelectTableCollection 
       Inherits System.Collections.CollectionBase
       Implements System.Collections.ICollectionSystem.Collections.IEnumerableSystem.Collections.IList 
    Remarks
    Use SelectTableCollection class to manage tables used in a query. To access the collection use the SelectStatement.Tables property.
    Example

    In the following sample we retrieve a collection of SelectTables from an MySqlSelectStatement object 'statement' and print them. For example, if statement represents the command

    SELECT * FROM test.dept tDept,test.emp tEmp
    

    the output of the sample would be the following:

    test.dept tDept
    test.emp tEmp
    
    SelectTableCollection collection = statement.Tables;
    foreach (SelectTable table in collection)
            Console.WriteLine(table.ToString());
    Dim collection As SelectTableCollection = statement.Tables
    For Each table In collection
            Console.WriteLine(table.ToString())
    Next
    Inheritance Hierarchy

    System.Object
       System.Collections.CollectionBase
          Devart.Common.SelectTableCollection

    See Also