Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Update table automatically

Posted on 2010-11-23
6
Medium Priority
?
538 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
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
Integration Management Part 2
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses
Course of the Month11 days, 20 hours left to enroll

564 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