The following example creates a
PgSqlCommand, then executes it by passing a string that is SQL SELECT statement, and a string to use to connect to the data source.
public void CreatePgSqlDataReader(string mySelectQuery,string pgConnectionString)
{
PgSqlConnection pgConnection = new PgSqlConnection(pgConnectionString);
PgSqlCommand pgCommand = new PgSqlCommand(mySelectQuery, pgConnection);
pgCommand.Connection.Open();
PgSqlDataReader pgReader = pgCommand.ExecuteReader();
try
{
while(pgReader.Read())
{
Console.WriteLine(pgReader.GetString(0));
}
}
finally
{
pgReader.Close();
pgConnection.Close();
}
}
Public Sub CreatePgSqlDataReader(mySelectQuery As String, _
pgConnectionString As String)
Dim pgConnection As New PgSqlConnection(pgConnectionString)
Dim pgCommand As New PgSqlCommand(mySelectQuery, pgConnection)
pgCommand.Connection.Open()
Dim pgReader As PgSqlDataReader = pgCommand.ExecuteReader()
Try
While pgReader.Read()
Console.WriteLine(pgReader.GetString(0))
End While
Finally
pgReader.Close()
pgConnection.Close()
End Try
End Sub