Real time system

  • Thread starter Thread starter George Varelas
  • Start date Start date
G

George Varelas

Hi,
I have the following subject.
I have a database (interbase) and I connect to it through odbc. I use Visual
Stidio 2005 as development tool and C# as programming language. What I need
is that:
I have a table in the database. I want each time a record is created in that
table, automatically, the dataset I have in my application (which is
connected to that table through a odbcDataAdapter) to be refreshed (model
push and not pop) in order to display the new record to my datagrid or
datagridview.

If I do it manually (it means connect to the database run the DataAdapter
and bring the data again in small time intervals) is very resource
consuming.

Is that possible? If yes can anyone help?

George
 
What you're describing is a very common request. It can be done with SQL
Server 2005 as it supports SqlDependency and leverages NotificationServices
to fire a "data changed" event in your application. No, I don't think it's
implemented in other less-sophisticated providers. However, I expect that
you could wire up Notification Services yourself and get it to help.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top