Solved

Getting Live Data By everybody in a multiuser environment

Posted on 2006-06-29
3
228 Views
Last Modified: 2013-11-13
Hi,
I am working on an application which will be used by many users at a time. According to the business requirements, the data statistics is displayed to the user based on which he will take decision. At the same time other users are updating the data and viewing the data.
Is there a way in Microsoft .NET environment  and MS SQL Server to refresh the data at the client end (datagrid) as soon as some other user makes changes to the related data without the user intervention.
I am using both the web forms and windows forms.

Also, is it possible to refresh the client data without distracting the user from the whole page/form/grid refresh.
0
Comment
Question by:akshay_sumeru
3 Comments
 
LVL 40

Accepted Solution

by:
RQuadling earned 500 total points
ID: 17009249
Yes.

The current buzzword for this sort of thing is AJAX.

Essentially the browser/.NET app makes request to the server on a regular basis for new data. This request happens behind the scenes. The response contains either NOCHANGE or the data to upgrade the display and client side code alters the environment.

I don't use .NET and don't really know where it fits in all of this.

If this was a normal web page...

Browser
1 - Use a hidden frame to get the data from the server. The visible frame uses JavaScript to extract the data and updates the display. No page refresh. Older method.
2 - Use XMLHttpRequest (either IE's ActiveX or built in object for FireFox, et al). Same sort of logic as 1.

There are MANY examples of AJAX sites. Googlemail for example.

For .NET, then I think you do the same sort of thing. Either use a hidden frame and use client side scripting to get the data from the frame onto the new page, or XMLHttpRequest.

One thing to be aware of, if your server side code generated the actual javascript required by the client to do all the changes, all the client code is basically 1 eval statement.

Very simple.

0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
add text to end of existing text in file 16 62
VBA color chart bars 12 67
topping1 challenge 7 53
Scripting vs. Programming languages 25 117
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
This article will show, step by step, how to integrate R code into a R Sweave document
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now