On reading your mail, i have the same doubt.

1) I have not seen any instances of locking a
table/database/row in any of the ADO.Net examples i
have seen so far.

2) In a disconnected dataset environment, how does the
system take into account the changes that might have
been made by another user, before this dataset updates
back the database ?