PgSqlDataTable Constructor(PgSqlCommand,PgSqlConnection)

In This Topic

Initializes a new instance of the PgSqlDataTable class.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal selectCommand As PgSqlCommand, _
   ByVal connection As PgSqlConnection _
)

public PgSqlDataTable( 
   PgSqlCommand selectCommand,
   PgSqlConnection connection
)

Parameters

selectCommand: A PgSqlCommand object used to select rows from the data source.
connection: A PgSqlConnection used to connect to the data source.

Example

This sample shows how to create a PgSqlDataTable and retrieve data from a table.

csharp

public void UseDataTable(PgSqlConnection pgConnection)
{
  PgSqlCommand pgCommand = new PgSqlCommand("SELECT * FROM Test.Dept");
  PgSqlDataTable myDataTable = new PgSqlDataTable(pgCommand,pgConnection);
  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;
  }
}

Visual Basic

Public Sub UseDataTable(ByVal pgConnection As PgSqlConnection)
  Dim pgCommand As PgSqlCommand = New PgSqlCommand("SELECT * FROM Test.Dept")
  Dim myDataTable As PgSqlDataTable = New PgSqlDataTable(pgCommand, pgConnection)
  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

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

Reference

PgSqlDataTable Class
PgSqlDataTable Members
Overload List

Send Feedback