Refreshing display of grid every 1 second

Avi

Hi Experts,

I would like to display the latest 500 events from a table which contains
over a million records. The speed of insertion is about 25 a second. How
can I display it and refresh the view every second to include the new 25 or
so events + the 475 out of 500 events from before.

What is the best method of so.

Thanks,

Avi

Nov 17 '05 #1

Subscribe Post Reply

1858

John B

Avi wrote:

Hi Experts,

I would like to display the latest 500 events from a table which contains
over a million records. The speed of insertion is about 25 a second. How
can I display it and refresh the view every second to include the new 25 or
so events + the 475 out of 500 events from before.

What is the best method of so.

Thanks,

Avi

You could update the grid on a timer.
However, if you update once a second, there is no way you could display
500 rows in a grid on the one screen and each second they would be reset
so you might want to revise the 500 down to 50-100 or so.

Just retrieve the last x records and rebind the grid each second.

JB

Nov 17 '05 #2

Similar topics

Datagrid refreshing ???

by: serge calderara | last post by:

Dear all, I am develpping a .NET vb application fro 2000 and XP. I have actually an Collection list of Type, where type have 4 variables inside This collection list can be really long. I then...

.NET Framework

Changing Data without Refreshing Page

by: Greg Scharlemann | last post by:

Given some recent success on a simple form validation (mainly due to the kind folks in this forum), I've tried to tackle something a bit more difficult. I'm pulling data down from a database and...

Javascript

Refreshing a Windows Form

by: Robert Clark | last post by:

This a pocket pc/smartphone questions mainly, but i thought i'd ask the question in the C# newsgroup. I have a form which i use to display information from a web service. From this form i open...

C# / C Sharp

Refreshing a datagrid at predetermined intervals?

by: Tom | last post by:

I have an ASP.NET web page coded in VB.NET (2003). That web page has a dropdown box on it which is loaded during the page_load event. When the user drops this down and selects a data item, the...

ASP.NET

Can't get information to display in a lable control on one form from another.

by: John Phelan-Cummings | last post by:

When I add the name of a new individual in a, bound form, it will not display that person’s name in a label control of a second unbound form. I have a scheduling program that I am working on. ...

Microsoft Access / VBA

ComboBox in DataGridView not refreshing

by: lv2compute | last post by:

I am having a problem with my datagridview. I have a small table that has two columns. The first column is bound to my dataset. The second column is a combobox. I add items to the combobox based on...

C# / C Sharp

Refreshing GridBagSizer

by: Steve S | last post by:

Hey guys, I'm stuck with using a GridBagSizer (wxPython) in a GUI Dialog and am having a frustrating time with refreshing it properly. Essentially, I've got to refresh the contents of the...

Python

Refreshing grid

by: veenna | last post by:

How can i refresh datagrid in vb.net. I want to display color in one cell in grid but when it loads first time it is working here is my code Public Class Dialog_Colorazione Const YEAR_START...

.NET Framework

Urgent : Data grid not refreshing properly

by: muddasirmunir | last post by:

i make a form whic has one data grid and one text box and one button when i write a name on tex box and click add the name stored in database successfully. now in the grid i want to show all the...

Visual Basic 4 / 5 / 6

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

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

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

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

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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

Online Marketing

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice