PgSqlCommand Constructor(String,PgSqlConnection)
Initializes a new instance of the
PgSqlCommand class with the text of the query and a
PgSqlConnection object.
The following example creates a
PgSqlCommand and sets some of its properties.
|
|---|
public void CreateCommand()
{
PgSqlConnection pgSqlConnection = new PgSqlConnection(
"host=server;database=test;user id=postgres;");
string mySelectQuery = "SELECT * FROM Test.Dept";
PgSqlCommand pgSqlCommand = new PgSqlCommand(mySelectQuery, pgSqlConnection);
pgSqlCommand.FetchSize = 100;
} |
|
|---|
Public Sub CreateCommand()
Dim pgSqlConnection As New PgSqlConnection( _
"host=server;database=test;user id=postgres;")
Dim mySelectQuery As String = _
"SELECT * FROM Test.Dept"
Dim pgSqlCommand As New PgSqlCommand(mySelectQuery, pgSqlConnection)
pgSqlCommand.FetchSize = 100
End Sub |