dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlDataTable Class / Connection Property
Example

Connection Property (MySqlDataTable)
Gets or sets the MySqlConnection used to connect to the data source.
Syntax
'Declaration
 
Public Shadows Property Connection As MySqlConnection
 

Property Value

A MySqlConnection object which provides a connection to the data source.
Remarks
This property is used by DeleteCommand, InsertCommand, SelectCommand, and UpdateCommand, in case when these properties do not have own created connection.

This property supports the InterForm technology.

Example
This sample shows how to create a MySqlDataTable and retrieve data from a table.
public void UseDataTable(MySqlConnection myConnection)
{
  MySqlDataTable myDataTable = new MySqlDataTable();
  myDataTable.Connection = myConnection;
  myDataTable.SelectCommand = new MySqlCommand("SELECT * FROM Test.Dept");
  try
  {
    myDataTable.Active = true;
    foreach(DataRow myRow in myDataTable.Rows)
    {
      foreach(DataColumn myCol in myDataTable.Columns)
      {
        Console.Write(myRow[myCol]+"\t");
      }
      Console.WriteLine();
    }
  }
  finally
  {
    myDataTable.Active = false;
  }
}
Public Sub UseDataTable(ByVal myConnection As MySqlConnection)
  Dim myDataTable As MySqlDataTable = New MySqlDataTable
  myDataTable.Connection = myConnection
  myDataTable.SelectCommand = New MySqlCommand("SELECT * FROM Test.Dept")
  Try
    myDataTable.Active = True
    Dim myRow As DataRow
    Dim myCol As DataColumn
    For Each myRow In myDataTable.Rows
      For Each myCol In myDataTable.Columns
        Console.Write(myRow(myCol) & Chr(9))
      Next myCol
      Console.WriteLine()
    Next myRow
  Finally
    myDataTable.Active = False
  End Try
End Sub
See Also