MS SQL Server Connectivity - How to make sure data queried is always newest data ?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

How to make sure data queried is always newest data ?

Dino Buljubasic

2006-02-14, 11:23 am

Hi,

I am using VS2005 (C#) and SQL Server 2000.

How can I make sure that:

1. Client A queries info from database and displays it in a list view
or other controls on a form. If Client B changes some of this info
that is displayed by client A, clint A gets its info updated

2. If clint B tries to delete data currently displayed by client A,
the attempt should fail.

How can I make sure from within my application that database data
displayed on the client's forms is always newest data?

Any help will be appreciated.

_dino_

Sponsored Links