PgSqlDataAdapter Constructor(String,String)
Initializes a new instance of the
PgSqlDataAdapter class with a
SelectCommand and a connection string.
The following example creates a
PgSqlDataAdapter, sets some of its properties, retrieves data from a table, and displays it.
|
|---|
public void CreateDataAdapter()
{
PgSqlDataAdapter myAdapter = new PgSqlDataAdapter("SELECT DeptNo, DName FROM Test.Dept",
"host=server;database=test;user id=postgres;");
myAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
DataSet myDataSet = new DataSet();
myAdapter.Fill(myDataSet,"Departments");
//Get all data from all tables within the dataset
foreach(DataTable myTable in myDataSet.Tables)
{
foreach(DataRow myRow in myTable.Rows)
{
foreach (DataColumn myColumn in myTable.Columns)
{
Console.Write(myRow[myColumn]+"\t");
}
Console.WriteLine();
}
Console.WriteLine();
}
} |
|
|---|
Public Sub CreateDataAdapter()
Dim myAdapter As PgSqlDataAdapter = New PgSqlDataAdapter("SELECT DeptNo, DName FROM Test.Dept", _
"host=server;database=test;user id=postgres;")
myAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey
Dim myDataSet As DataSet = New DataSet
myAdapter.Fill(myDataSet, "Departments")
Dim myTable As DataTable
Dim myRow As DataRow
Dim myColumn As DataColumn
' Get all data from all tables within the dataset
For Each myTable In myDataSet.Tables
For Each myRow In myTable.Rows
For Each myColumn In myTable.Columns
Console.Write(myRow(myColumn) & Chr(9))
Next myColumn
Console.WriteLine()
Next myRow
Console.WriteLine()
Next myTable
End Sub |
