how to manage sql server transaction in desktop networking application vb.net2005?

hi

i want to know that how to manage the sql server transaction in a big desktop networking application

for example

there are 200 tables in database. many of that tables have relatationship. i have a form in frontend which holds nere ablut 50 tables deffrent calculated amount. i want to ADD, EDIT and DELETE, SAVE(commit), CANCEL(roll back) them and same time another use will do the same work from another pc. if there are 100 user does the same work (add, edit, delete, save, cancel) how could i magage my sql server data

i also want to know that

1 kind of proffessionsl way to use sql server and vb.net
2 what kind of septs to develop a desktop networking application with sql server
3 how i could manage the transaction in sql server when there are many-many user working in the same database(add, edit, delete, save-commit, cancel-rollback).<img src="images/emoticons/smile_baringteeth.gif">

Answer this question

how to manage sql server transaction in desktop networking application vb.net2005?

Acusis

http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnbda/html/psent.asp

This article can be a starting point.

Thanks
how to manage sql server transaction in desktop networking application vb.net2005?

Answer this question