DataGrid and Dynamic Recordset

[vladab]

Hi, everybody,
I am using DataGrids to show database data (SQL 2000) in my VB application, let the user to select the record in the DataGrid and see the details. 10 users. I use Client cursor and Static recordset. Now the User wants to see all additions that are made to the data in the database. I was thinking about Dynamic Recordset and Server Connection. But DataGrid control doesn't want to work with Dynamic Recordset (recordset is not bookmarkable).
Any sugestions how can I show dynamic data?
Thank you.

 

[CCLINT]

Add a button [lightening bolt] to the form or toolbar that allows the user to refresh the data.

They got to be reasonable about this - for their own benifit.
What would happen if data was added/changed/deleted every 5 seconds? The client would then really have something to complain about, esp. when then screen and data that they are currently looking at blinks and changes often.
I could only see doing this when displaying single records, or dynamic graphs, or critical situations, or in real surveillance situations, for the most, but not your every-day normal data.

Dynamic cursors the slowest and have alot of overhead, so use this sparingly.
][/b]][/i]][/u]*******************************************************
[sub]General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!