i'm bit confused.
Code: Select all
{
PgSqlAlerter ZPgEventAlerter = new PgSqlAlerter();
PgSqlConnection myConn = new PgSqlConnection();
public Form1()
{
PgSqlConnectionStringBuilder builder = new PgSqlConnectionStringBuilder();
builder.ConnectionString = "host=localhost;database=db;user id=postgres;password=postgres";
builder.ApplicationName = "APP";
myConn.ConnectionString = builder.ConnectionString;
InitializeComponent();
ZPgEventAlerter.Connection = myConn;
ZPgEventAlerter.AlertNames = "shift_update";
ZPgEventAlerter.Alert += ZPgEventAlerter_Alert; ;
ZPgEventAlerter.Stopped += ZPgEventAlerter_Stopped;
ZPgEventAlerter.Error += ZPgEventAlerter_Error;
ZPgEventAlerter.Start();
myConn.Open();
//doing some select
myConn.Close();
}
Thx for help!