Refresh Database

[dglienna]

If the grid is active, you'd use RowVersion

http://www.mssqltips.com/tip.asp?tip=1501

[DataMiser]

I looked at the link but I still do not see where this is of any use to the original question. If user a is viewing a grid that is currently displaying 100 records and User B inserts a record User A will not see the record that was added until User A refreshs the data and there is no indication if any record has been added prior to this action.

I'll ask one more time how does a row lock for edit on a different machine magically refresh records on yet another machine or 499 machines?

[dglienna]

User B checks the ROWVERSION table to see WHICH records have been modified. It refreshes the table if changes are pending.

Look at this site: http://www.devexpress.com/Products/N...WinForms/Grid/

[RusdyRIP]

User B checks the ROWVERSION table to see WHICH records have been modified. It refreshes the table if changes are pending.

Look at this site: http://www.devexpress.com/Products/N...WinForms/Grid/

do u mean it refreshed without making any code?

thx

[dglienna]

Yes. They right the code to only get values for the results that are VISIBLE on the screen (Server Mode)

If your query returned 1000 records, and your grid showed 10 lines, it'd load in the time to query 10 records. Pretty cool controls.