sql adapter transaction problem

[adwaitjoshi]

Hi I have the following code

 Dim cb As New SqlCommandBuilder(_sqladapter)
_sqladapter.UpdateCommand = cb.GetUpdateCommand()
_sqladapter.InsertCommand = cb.GetInsertCommand()
_sqladapter.DeleteCommand = cb.GetDeleteCommand()
_sqladapter.Update(_dataset.Tables(_tablename))

the above code works fine out of a transaction. When I say BeginTransaction I get an error

Error updating SQL Adapter. The exception Execute requires the command to have a transaction object when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized..

hence I added the code

_sqladapter.UpdateCommand.Transaction = gobjDatabase.CurrentTransaction
_sqladapter.InsertCommand.Transaction = gobjDatabase.CurrentTransaction
_sqladapter.DeleteCommand.Transaction = gobjDatabase.CurrentTransaction

_sqladapter.UpdateCommand = cb.GetUpdateCommand()
_sqladapter.InsertCommand = cb.GetInsertCommand()
_sqladapter.DeleteCommand = cb.GetDeleteCommand()
_sqladapter.Update(_dataset.Tables(_tablename))

now I get an error

Error updating SQL Adapter. The exception Object reference not set to an instance of an object..

what am I doing wrong? Can someone please guide me?

 

[JohnH]

Try to assign the SqlTransaction instance returned by BeginTransaction method. (before Update method)

 

[adwaitjoshi]

gobjDatabase.CurrentTransaction returns the current transaction object obtained from begin transaction