PgSqlDataTable Class

On this page

Represents a single object that provides all of the functionality needed to retrieve and manipulate data from a PostgreSQL data source.

Syntax

Visual Basic
C#


'Declaration Public Class PgSqlDataTable Inherits Devart.Common.DbDataTable Implements System.ComponentModel.IComponent, System.ComponentModel.IListSource, System.ComponentModel.ISupportInitialize, System.ComponentModel.ISupportInitializeNotification, System.IDisposable, System.IServiceProvider, System.Runtime.Serialization.ISerializable, System.Xml.Serialization.IXmlSerializable

'Declaration
 
Public Class PgSqlDataTable 
   Inherits Devart.Common.DbDataTable
   Implements System.ComponentModel.IComponent, System.ComponentModel.IListSource, System.ComponentModel.ISupportInitialize, System.ComponentModel.ISupportInitializeNotification, System.IDisposable, System.IServiceProvider, System.Runtime.Serialization.ISerializable, System.Xml.Serialization.IXmlSerializable


public class PgSqlDataTable : Devart.Common.DbDataTable, System.ComponentModel.IComponent, System.ComponentModel.IListSource, System.ComponentModel.ISupportInitialize, System.ComponentModel.ISupportInitializeNotification, System.IDisposable, System.IServiceProvider, System.Runtime.Serialization.ISerializable, System.Xml.Serialization.IXmlSerializable

public class PgSqlDataTable : Devart.Common.DbDataTable, System.ComponentModel.IComponent, System.ComponentModel.IListSource, System.ComponentModel.ISupportInitialize, System.ComponentModel.ISupportInitializeNotification, System.IDisposable, System.IServiceProvider, System.Runtime.Serialization.ISerializable, System.Xml.Serialization.IXmlSerializable

Remarks

The PgSqlDataTable 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, PgSqlDataTable replaces PgSqlConnection, PgSqlCommand, PgSqlDataAdapter, and PgSqlCommandBuilder classes with all-in-one class. When a PgSqlDataTable 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 PgSqlDataTable you can avoid explicit creation of PgSqlConnection and PgSqlCommand 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.

PgSqlDataTable 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 PgSqlDataTable class is designed to employ both connected and disconnected data access models. It also provides functionality for asynchronous fill operations.

The PgSqlDataTable 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 PgSqlDataTable please refer to topic PgSqlDataTable Advanced Features.

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

Note: This class is not available in .NET Standard 1.3 compatible assembly. It is available only in the assembly for full .NET Framework and .NET Standard 2.0 compatible assemblies.

This class is available only in Professional Edition. It is not available in Standard and Mobile Editions.

Example

This sample shows easiness of use of PgSqlDataTable. The sample creates a PgSqlDataTable 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.

csharp


public void UseDataTable() { PgSqlDataTable myDataTable = new PgSqlDataTable("SELECT * FROM Test.Dept", "host=server;database=test;user id=postgres;"); 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 void UseDataTable()
{
  PgSqlDataTable myDataTable = new PgSqlDataTable("SELECT * FROM Test.Dept", 
      "host=server;database=test;user id=postgres;");
  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;
  }
}

Visual Basic


Public Sub UseDataTable() Dim myDataTable As PgSqlDataTable = New PgSqlDataTable("SELECT * FROM Test.Dept", _ "host=server;database=test;user id=postgres;") 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

Public Sub UseDataTable()
  Dim myDataTable As PgSqlDataTable = New PgSqlDataTable("SELECT * FROM Test.Dept", _
      "host=server;database=test;user id=postgres;")
  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.PostgreSql.PgSqlDataTable

Reference

PgSqlDataTable Members
Devart.Data.PostgreSql Namespace
PgSqlConnection Class
PgSqlDataReader Class

Send Feedback