469,934 Members | 1,983 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

Real time display of database data


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

incognito...updated almost daily
http://kentpsychedelic.blogspot.com
Nov 23 '05 #1
8 3051
You can write a sheduled thread in your client application that check
periodically for data changes.
"Keith" <it****@keith.me> ha scritto nel messaggio
news:xw*****************@newsread3.news.pas.earthl ink.net...

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

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

Nov 23 '05 #2
Marco Frontini wrote:
You can write a sheduled thread in your client application that check
periodically for data changes.
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?


"Keith" <it****@keith.me> ha scritto nel messaggio
news:xw*****************@newsread3.news.pas.earthl ink.net...
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
--

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


--

incognito...updated almost daily
http://kentpsychedelic.blogspot.com
Nov 23 '05 #3

"Keith" <it****@keith.me> wrote in message
news:xw*****************@newsread3.news.pas.earthl ink.net...

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


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/de...rarch_6mia.asp

/Fredrik

7Fredrik
Nov 23 '05 #4
Keith,

The main concept in dotNet about databases is disconnected and with that
optimistic concurrency.

With notifying changes you try in my opinion to create a kind of pessimistic
concurrency and a connected database.

I think that the article about the concurrency also covers your problem.

http://msdn.microsoft.com/library/de...cychecking.asp

Just my thought,

Cor
Nov 23 '05 #5
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

"Keith" <it****@keith.me> wrote in message
news:xw*****************@newsread3.news.pas.earthl ink.net...

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

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

Nov 23 '05 #6
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" <it****@keith.me> ha scritto nel messaggio
news:S4*****************@newsread3.news.pas.earthl ink.net...
Marco Frontini wrote:
You can write a sheduled thread in your client application that check
periodically for data changes.


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?


"Keith" <it****@keith.me> ha scritto nel messaggio
news:xw*****************@newsread3.news.pas.earthl ink.net...
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
--

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


--

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

Nov 23 '05 #7

WOW!

Is it that simple?

Cool...

Marco Frontini wrote:
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" <it****@keith.me> ha scritto nel messaggio
news:S4*****************@newsread3.news.pas.earthl ink.net...
Marco Frontini wrote:
You can write a sheduled thread in your client application that check
periodically for data changes.


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?


"Keith" <it****@keith.me> ha scritto nel messaggio
news:xw*****************@newsread3.news.pas.ear thlink.net...
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
--

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


--

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


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

Texeme Textcasting Technology
http://texeme.com

Nov 23 '05 #8

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 Frontini wrote:
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" <it****@keith.me> ha scritto nel messaggio
news:S4*****************@newsread3.news.pas.earthl ink.net...
Marco Frontini wrote:
You can write a sheduled thread in your client application that check
periodically for data changes.


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?


"Keith" <it****@keith.me> ha scritto nel messaggio
news:xw*****************@newsread3.news.pas.ear thlink.net...
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
--

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


--

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


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

Texeme Textcasting Technology
http://texeme.com

Nov 23 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Keith | last post: by
3 posts views Thread by Ted Burhan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.