Hi,

  I am just getting into to Programming VB .NET. One thing that come into mind is that is VB .Net is intended for a multi-user environment? The reason I ask this question is that since that is being querried from the database are being manipulated in memory; therefore, when another user access that same information and make changes to those data then it would not reflect the change that is currently present in the other user memory. This is because of how dataset and dataview are designed.

Am I right or am I wrong?

Nicolas

This situation is known as data concurrency. If you expect that your users will be looking at/changing the same data you have to take this into account and write your application accordingly. If you use the .NET "wizards" to add data IO controls such as data adapters to your forms, it can construct update queries that use what is known as "pessimistic concurrency checks" on the updates. I'll explain in a simple example. Let's say we have a table "Users" with this structure:

The key field on this table is UserID. Normally when you update this record, you use a query like this:

UPDATE Users SET FirstName='Peter' WHERE UserID=12

This is an optimistic update. You update it hoping that no one else has changed the FirstName field since you looked at it. The pessimistic update for this same record would look like this:

UPDATE Users SET FirstName='Peter' WHERE UserID=12 AND FirstName='Nicolas'

This query will only update the data if it hasn't changed since you looked at it. The ADO.NET DataTable keeps track of changes to rows and you can construct queries that have parameters tied to original values on changed rows. This allows for pessimistic updates that tell you if you can't update the row because of changed data.

-Peter