'Declaration Public Shadows Property Connection As PgSqlConnection
public new PgSqlConnection Connection {get; set;}
'Declaration Public Shadows Property Connection As PgSqlConnection
public new PgSqlConnection Connection {get; set;}
This property supports the InterForm technology.
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