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

Reference

PgSqlDataTable Class
PgSqlDataTable Members
Overload List

Send Feedback