CreateCommand Method (PgSqlConnection)
Creates and returns a
PgSqlCommand object associated with the
PgSqlConnection.
In this sample
PgSqlCommand object is created. It is automatically associated with
PgSqlConnection that created it.
public void CreatePgSqlCommand(string myConnString)
{
PgSqlConnection pgConnection = new PgSqlConnection(myConnString);
PgSqlCommand pgCommand = pgConnection.CreateCommand();
pgCommand.CommandText = "INSERT INTO DEPT VALUES (50,'Development','Philadelphia')";
pgConnection.Open();
try
{
pgCommand.ExecuteNonQuery();
}
finally
{
pgConnection.Close();
}
}
Public Sub CreatePgSqlCommand(ByVal myConnString As String)
Dim pgConnection As New PgSqlConnection(myConnString)
Dim pgCommand As PgSqlCommand = pgConnection.CreateCommand()
pgCommand.CommandText = "INSERT INTO DEPT VALUES (50,'Development','Philadelphia')"
pgConnection.Open()
Try
pgCommand.ExecuteNonQuery()
Finally
pgConnection.Close()
End Try
End Sub