Hi Guys,
I am using ASP.NET with C# to create a web page that pulls a list of data from a database and displays it in an HTML table on a web page. However the list is bigger than the page so I want it to refresh every 20 seconds or so and show the next page until it gets to the last page then go back to the start.
What is the easiest way to achieve this??
Thanks in advance for any help.
Chris
Loading
vijayPosted Jan 21, 2011, 2:08 AM
For solving your probs ..you add timer control set for an every 20 seconds its calls the query and update to the table...
i think this way to achive this....
regards,
vijay
http://vbdotnetaddict.blogspot.com
CrishPosted Jan 20, 2011, 9:38 AM
you can use jquery for your solution (http://www.malsup.com/jquery/cycle/int2.html)
Chris JamesPosted Jan 19, 2011, 7:48 AM
Thanks for your response. Currently I am using a while loop to loop through a number of rows returned from a database table based on a query. So essentially the pseudo code would be
While There are more rows
{
Get next row from the dataset
Create new HTML Table Row
Add it to the table
}
However the number of rows is more than I can display on a single page in the table so similar to an airport departure screen I want to show the first say 10 then the next 10 until I have displayed all of the rows and, return to the first page and repeat. Between each page I will need to pause for say 10 seconds..
Let me know if you need any further info or clarification.
Thanks for your help.
Chris
Madhu KPosted Jan 19, 2011, 7:29 AM
To refresh the page continuously timer control will be helpful.