On 1/16/08, Database Team [EMAIL PROTECTED] wrote:
How to handle the Firebird Event notification from my .NET Application.
I want to know what changes are made to the Database Tables.
Hello, here is example of processing events:
static void Main(string[] args)
{
FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
cs.DataSource = localhost;
cs.Database = employee.fdb;
cs.UserID = SYSDBA;
cs.Password = masterkey;
cs.Charset = NONE;
cs.Pooling = false;
FbConnection connection = new FbConnection(cs.ToString());
connection.Open();
FbRemoteEvent revent = new FbRemoteEvent(connection);
revent.AddEvents(new string[] { new_order });
// Add callback to the Firebird events
revent.RemoteEventCounts += new FbRemoteEventEventHandler(EventCounts);
// Queue events
revent.QueueEvents();
string sql = INSERT INTO SALES (PO_NUMBER, CUST_NO, SALES_REP,
ORDER_STATUS, +
ORDER_DATE, SHIP_DATE, DATE_NEEDED,
PAID, QTY_ORDERED, TOTAL_VALUE, +
DISCOUNT, ITEM_TYPE) VALUES
(@po_number, 1004, 11, 'new', +
'1991-03-04 00:00:00', '1991-03-05
00:00:00', NULL, 'y', 10, 5000, +
0.10001490116, 'hardware');;
FbCommand command = new FbCommand(sql, connection);
command.Parameters.Add(@po_number, FbDbType.Char, 8);
for (int i = 360; i 365; i++)
{
command.Parameters[0].Value = V91E0 + i.ToString();
command.ExecuteNonQuery();
}
System.Threading.Thread.Sleep(2000);
connection.Close();
}
static void EventCounts(object sender, FbRemoteEventEventArgs args)
{
Console.WriteLine(Event {0} has {1} counts., args.Name, args.Counts);
}
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider