i have a problem and it's hard to explain but don't know the solution for many years,pls help me...

A is viewing database from datagrid.
after that
B inserting a new data to database from different computer.
A still looking datagrid from database before updated.

if he don't click refresh or using timer how can the datagrid automatically refresh the data from database without using button or timer.
i don't like using timer cause it eat resources a lot.

thx
sorry bad english

Hi
There is no way for you to do this without a timer, unless the database informs your application that a record has changed.
I have seen this in n-tier apps, where updates/requests from the client go into a cache. The client application connects to this cache - NOT to the database. the client application also registers for events in the cache (like "Supplier added" and such).
The net result usually is that the grid refreshes anyway, thereby resulting in a complete download from the cache/datasource.
Timers do not consume much in the way of resources, you can create your own static Timer which means your application has a single timer object. Your aplication then uses this Timer object not the windows.forms one

Hope this helps
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)