Keep a data grid live? 
Author Message
 Keep a data grid live?

Is there a way to have a data grid that is always showing what is in a
table?

I have an ADO connection to an Access DB. I have a Data Grid that shows
me all records as of when I open the Data Grid. But if someone adds a
record to that table, I do not see it in the Data Grid, unless I refresh
it. Is there a way to keep it live?



Fri, 07 Jan 2005 09:52:02 GMT  
 Keep a data grid live?
You can either:

Refresh/requery every few seconds.
Build messaging between client applications to notify of updates.
Use dynamic cursor type if your OLEDB and database support it. Records are
meant to update as you scroll, I don't use this so couldn't say how well it
works in a live application.

--
Mike Collier BSc (Hons) - www.adoanywhere.com
ADO Object Browser and COM Server.
Consultancy and Design - ADO & Database Specialists.


Quote:
> Is there a way to have a data grid that is always showing what is in a
> table?

> I have an ADO connection to an Access DB. I have a Data Grid that shows
> me all records as of when I open the Data Grid. But if someone adds a
> record to that table, I do not see it in the Data Grid, unless I refresh
> it. Is there a way to keep it live?



Fri, 07 Jan 2005 20:04:09 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. How best to keep Flexgrid Data live?

2. Keeping a component object variable "live"

3. Binary Data in SQL 2000/Conver to Bitmap Data For Data Grid View

4. Copy live data

5. free p2p win32 web server / shares live word data

6. live data feed ???

7. changing MDB scheme with live data in it

8. changing MDB schema with live data in it

9. data grids/ms flex grids

10. which grid to use: DBGrid, data grid, MSFlexgrid

 

 
Powered by phpBB® Forum Software