dotConnect for DB2 Documentation
Devart.Data.DB2 Namespace / DB2DataTable Class
Members Example

In This Topic
    DB2DataTable Class
    In This Topic
    Represents a single object that provides all of the functionality needed to retrieve and manipulate data from a DB2 data source.
    Syntax
    Remarks

    The DB2DataTable class extends the Devart.Common.DbDataTable class to provide a single object that can be used to access and update data from a data source. Actually, DB2DataTable replaces DB2Connection, DB2Command, DB2DataAdapter, and DB2CommandBuilder classes with all-in-one class. When a DB2DataTable object is created, the default values of its constituent parts are set to reasonable defaults, meaning that the programmer can create a single object and immediately use it to retrieve and manipulate data from a data source.

    By using DB2DataTable you can avoid explicit creation of DB2Connection and DB2Command objects. When appropriate form of constructor is used, these objects are created automatically when you retrieve data from a data source. It allows you to cut down the size of the written code.

    DB2DataTable allows you to automate loading of subsets of data either by selecting Devart.Common.DbTable.StartRecord and MaxRecords properties or by using Fill or FillPage methods that support passing parameter values into the query text.

    The DB2DataTable class is designed to employ both connected and disconnected data access models. It also provides functionality for asynchronous fill operations.

    The DB2DataTable class can be fully adjusted at design-time. You may retrieve data at design-time from a data source by setting Devart.Common.DbTable.Active property to true.

    For more information on advanced features of DB2DataTable please refer to topic DB2DataTable Advanced Features.

    This class supports cross-form data binding with the InterForm Technology.

    Example
    This sample shows easiness of use of DB2DataTable. The sample creates a DB2DataTable object, passing it SQL query text and connection string, retrieves data from a table and modifies it. Content of the table is printed to console then. Notice that no other component needs to be created by programmer.
    public void UseDataTable()
    {
      DB2DataTable myDataTable = new DB2DataTable("SELECT * FROM Dept", 
          "user id=db2admin;server=db2;database=SAMPLE;");
      try
      {
        myDataTable.FetchAll = true;
            myDataTable.Active = true;
        myDataTable.Rows[3]["DName"] = "Researches";
        Console.WriteLine(myDataTable.Update()+" rows updated.");
        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.FetchAll = True
            myDataTable.Active = True
        myDataTable.Rows(3)("DName") = "Researches"
        Console.WriteLine(myDataTable.Update() & " rows updated.")
        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
    Inheritance Hierarchy

    System.Object
       System.ComponentModel.MarshalByValueComponent
          System.Data.DataTable
             Devart.Common.DbDataTable
                Devart.Data.DB2.DB2DataTable

    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also