I'm looking for a basic outline of the steps that are usually used in
a multi-user database app. So far I've only played with the single-
user situation, so when I load the form I load the form's datagrid...

Try
  Me.TblMy_TableTableAdapter.Fill(Me.My_DBDataSet.tblMy_Table)
Catch ex As Exception
  MsgBox("Database Error: " & ex.Message)
End Try

And then when the user exits the form I simply save...

Try
   Me.Validate()
   Me.TblMy_TableBindingSource.EndEdit()
   If Me.My_DBDataSet.HasChanges = True Then
       If MsgBox("Post Edits to Remote Database?", MsgBoxStyle.YesNo,
_
           "UPDATES PENDING") = MsgBoxResult.Yes Then
            Me.TableAdapterManager.UpdateAll(Me.My_DBDataSet) ' update
remote database
       End If
   End If
Catch ex As Exception
    MsgBox("Database Error: " & ex.Message)
End Try
Me.Close()

Now what is the outline of the save operation for a simple non-
cascading multi-user situation? I'm thinking you probably want/need to
identify your updates, inserts and deletes and then go through some
sort of read-lock-write-unlock loops? I have no idea. I have no
exposure to this more complex stuff at all.

Thanks,

Dave

Reply via email to