نحوه استفاده از Transaction در 2005

[مطهر]

dcNorthwind.Open()



Dim transaction1 As SqlClient.SqlTransaction

transaction1 = dcNorthwind.BeginTransaction()



daCustomers.UpdateCommand.Transaction = transaction1

daOrders.UpdateCommand.Transaction = transaction1



Try

    daCustomers.Update(dsNorthwind1)

    daOrders.Update(dsNorthwind1)

    transaction1.Commit()



Catch dbcex As DBConcurrencyException

    MessageBox.Show("Update Failed, Concurrency Exception")

    transaction1.Rollback()



Catch ex As Exception

    MessageBox.Show("Update Failed")

    transaction1.Rollback()



Finally

    dcNorthwind.Close()

End Try

من از این کد کمک گرفتم در 2005
فکر نکنم با 2003 تفاوت داشته باشه