dotConnect for DB2 Documentation
Devart.Data.DB2 Namespace / DB2DataTable Class / DB2DataTable Constructor / DB2DataTable Constructor(String,String)
The text of the selection command.
Connection string used to connect to the data source.
Example

In This Topic
DB2DataTable Constructor(String,String)
In This Topic
Initializes a new instance of the DB2DataTable class.
Syntax
'Declaration
 
Public Function New( _
   ByVal selectCommandText As String, _
   ByVal connectionString As String _
)
 

Parameters

selectCommandText
The text of the selection command.
connectionString
Connection string used to connect to the data source.
Example
This sample shows how to create a DB2DataTable and retrieve data from a table.
public void UseDataTable()
{
  DB2DataTable myDataTable = new DB2DataTable("SELECT * FROM Dept", 
      "user id=db2admin;server=db2;database=SAMPLE;");
  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()
  Dim myDataTable As DB2DataTable = New DB2DataTable("SELECT * FROM Dept", _
      "user id=db2admin;server=db2;database=SAMPLE;")
  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