Real time system

27 Mar 2006 9:45 AM

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

27 Mar 2006 10:32 AM

William (Bill) Vaughn

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.
__________________________________

Show quote

"George Varelas" <gvare***@casinorio.gr> wrote in message
news:%23Y8N6MYUGHA.2492@TK2MSFTNGP11.phx.gbl...
> 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
>