473,394 Members | 1,965 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

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 3179
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Keith | last post by:
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...
3
by: Ted Burhan | last post by:
Hi all, I'm trying to display a real-time data in one form or another (i.e. animation/graphic file, or just a text) in asp.net. The data for the images/text is retrieved from a SQL Server...
7
by: jude | last post by:
Hello, We are starting to discuss a new ASP.NET application that will be a data acquisition display application. The data to be displayed will come from multiple sources--database tables, serial...
6
by: Charles | last post by:
Hello, I have a specific need to stream text from a database to a browser window in real time. Basically, I need this for a chat application such as phplive. A browser window needs to display in...
2
by: Dale | last post by:
Access 2003 I have an access database used for scoring a high school sporting event. Data is entered as scores are turned in from the different events throughout the day. I would like to...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.