Real time display of database data

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

Say I write a little c# client and have a database. I want multiple
people to use the client, which will display a datagrid, or tree control
with data from the databse. The client will allow updates, insertions,
deletes of data that is populated from a table in the database.

Now, how do I get the client to show real time updates? So that if user
(A) deletes a record or changes a field, user (B) sees it right away ?

Should I use:

a. web services
b. wse 2.0
c. remoting
d. other
 
You can write a sheduled thread in your client application that check
periodically for data changes.
 
Keith said:
Say I write a little c# client and have a database. I want multiple
people to use the client, which will display a datagrid, or tree control
with data from the databse. The client will allow updates, insertions,
deletes of data that is populated from a table in the database.

Now, how do I get the client to show real time updates? So that if user
(A) deletes a record or changes a field, user (B) sees it right away ?

Should I use:

a. web services
b. wse 2.0
c. remoting
d. other
Click to expand...

I guess that depends on the kind of database you want to use. In SQL Server,
there's something called notification services that you could use. Other
database vendors should have similar solutions.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlntsv/htm/ns_overarch_6mia.asp

/Fredrik

7Fredrik
 
Marco said:
You can write a sheduled thread in your client application that check
periodically for data changes.
Click to expand...

Good idea.

But is there a way to make it more like a push client, where the server
can message to a client listener...I thought WSE 2.0 could do that?


 
Hi, Keith:
You need a notification system. See the article at
http://www.udaparts.com/articles/chatservice.htm. Wish it is helpful to you.


Yuancai (Charlie) Ye
RDB, a tool for fast and securely accessing remote databases with dial-up,
cable, DSL and wireless modems

Fast and securely accessing all of remote data sources anywhere with
SocketPro using batch/queue, non-blocking and parallel computation

See 30 well-tested and real OLEDB examples
www.udaparts.com
 
Yes, if your data access is done via webservice you can subscribe your
clients to recieve data changed notification, your must move "data changed"
check into webservice code.

Keith said:
Marco said:
You can write a sheduled thread in your client application that check
periodically for data changes.
Click to expand...

Good idea.

But is there a way to make it more like a push client, where the server
can message to a client listener...I thought WSE 2.0 could do that?
Click to expand...
 
WOW!

Is it that simple?

Cool...

Marco said:
Yes, if your data access is done via webservice you can subscribe your
clients to recieve data changed notification, your must move "data changed"
check into webservice code.

Good idea.

But is there a way to make it more like a push client, where the server
can message to a client listener...I thought WSE 2.0 could do that?
Click to expand...


--
incognito...updated almost daily
http://kentpsychedelic.blogspot.com

Texeme Textcasting Technology
http://texeme.com
Click to expand...
 
This article seems to provide some answers:

http://www.codeproject.com/csharp/WebServicecache.asp
How to use data caching in a .NET Windows Forms application



Marco said:
Yes, if your data access is done via webservice you can subscribe your
clients to recieve data changed notification, your must move "data changed"
check into webservice code.

Good idea.

But is there a way to make it more like a push client, where the server
can message to a client listener...I thought WSE 2.0 could do that?
Click to expand...


--
incognito...updated almost daily
http://kentpsychedelic.blogspot.com

Texeme Textcasting Technology
http://texeme.com
Click to expand...
 
Back
Top