Solved

Update table automatically

Posted on 2010-11-23
6
506 Views
Last Modified: 2012-06-21
Hello,

Scenario:  We have multiple tables in .aspx pages  that we manually populate in code behind with data sets that are filled and retrieved from SQL 2008 database via data access layer.  

Issue:  What is the best way to dynamically update these tables without any user interaction or refreshing of the page?  

For example: say the table contains rows of games that are offered for entry.  Users enter the games until they are full, then they should disappear from the table.  So if user #1 enters the game and fills the last spot, this game should instantly disappear from the table for user #2 who is looking at the table of games.

Looking for a best practice solution which takes performance into affect as the number one priority.  Using asp.net 3.5 and sql 2008

Thanks.
0
Comment
Question by:kruegerste
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 7

Expert Comment

by:dxdinh
ID: 34202597
combine ajaxify plug in from jquery and set timer to call update those table every 1 second ?

jquery
http://www.jquery.com
 
ajaxify
http://max.jsrhost.com/ajaxify/
0
 
LVL 29

Expert Comment

by:Kumaraswamy R
ID: 34202664
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 34205103
Hi, you can use AJAX or JQuery. As per my opinion jQuery is best. However, both have some issue with Masterpage.
0
The Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

 
LVL 4

Author Comment

by:kruegerste
ID: 34205514
PatelAlpesh - what issue do you refer to with MasterPages?

It seems jquery/ajax is probably  the obvious choice.  But I'm not sure logistically how this would work. Looking for a more detailed solution.

 I think we prefer to use jquery, but would we be able to use jquery ajax features if we are using .net web controls like a gridview or repeater to display the data? It may also contain .net native paging and filtering.  Not sure how to update a table like this without rebinding it in the code-behind.

Going a step further, what is the best solution (high level)  to get data from a database, build a table like display (i.e. gridview) and then update it dynamically?  
0
 
LVL 7

Accepted Solution

by:
dxdinh earned 500 total points
ID: 34207247


  you can use handler ashx to retrieve your table result. There are tons of examples to do that but I guess you have to do some research

http://www.mikesdotnetting.com/Article/104/Many-ways-to-communicate-with-your-database-using-jQuery-AJAX-and-ASP.NET

http://sites.google.com/site/spyderhoodcommunity/tech-stuff/usingjqueryinaspnetappswithhttphandlersashx

 I learn my asp.net & jquery from Rick - he has tons of tutorials for you to start with
http://www.west-wind.com/weblog/posts/509108.aspx


0
 
LVL 4

Author Closing Comment

by:kruegerste
ID: 34210195
Thanks, will look into this stuff.
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

688 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