Connection Property (PgSqlDataTable)
Gets or sets the
PgSqlConnection used to connect to the data source.
Property Value
A
PgSqlConnection object which provides a connection to the data source.
This sample shows how to create a
PgSqlDataTable and retrieve data from a table.
public void UseDataTable(PgSqlConnection pgConnection)
{
PgSqlDataTable myDataTable = new PgSqlDataTable();
myDataTable.Connection = pgConnection;
myDataTable.SelectCommand = new PgSqlCommand("SELECT * FROM Test.Dept");
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(ByVal pgConnection As PgSqlConnection)
Dim myDataTable As PgSqlDataTable = New PgSqlDataTable
myDataTable.Connection = pgConnection
myDataTable.SelectCommand = New PgSqlCommand("SELECT * FROM Test.Dept")
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