Monthly Archives: February 2010

1 post

Update DataTable in Transaction

We all know that if you need to insert/update data in several database tables that have relationship with each other, then you will need to make sure the insert/update process is completed in a transaction to ensure the data integrity. With stored procedure, it is not hard to perform transaction, but what if you are using DataTable? In this post, I will show how to use TransactionScope to implement transaction for DataTable update. Suppose we […]