How to work with commandbuilder and transactions ?????

  • Thread starter Thread starter Joao Santa Barbara
  • Start date Start date
J

Joao Santa Barbara

hi all i need to work with the commandbuilder and with a transaction object
how can i do this ????

thks
JSB


please don´t tell me that i have to do this

ex:
mycommand.transaction = commandbuilder.insertcommand

is this logic ????? i don´t think so ...
 
Hello,

Joao Santa Barbara said:
hi all i need to work with the commandbuilder and with a transaction object
how can i do this ????
Click to expand...

Please do not x-post ADO.NET related questions to the VB.NET language
group.
 
Do you know that I'd almost bet you would have won your MVP award from only
the number of posts made just to turn people to the right newsgroup.


;-D
 
Hello,

One Handed Man said:
Do you know that I'd almost bet you would have won your MVP
award from only the number of posts made just to turn people to
the right newsgroup.
Click to expand...

I got it for my work in the German language ngs. There are fewer OT
postings than here.
 
Herfried and OHT,
I got it for my work in the German language ngs There are fewer OT
postings than here.
Click to expand...

I did want to write, You would see him (and Armin) in the German groups but
I thought, why would I but now you did it yourself Herfried.
Cor
 
Joao:

Set all of the CommandBuilder Logic irrespective of the transaction...

so say you get your commandbuilder data built...
sqlCmdBuilder = New SqlClient.SqlCommandBuilder(da2)



And now you want to update....



Dim dbTrans as OleDbTransaction //or SQL or ODBC

dbTrans = someConnection.BeginTransaction

Try

myDataAdapter.Update(soemDataTable_DataSet)

transaction.Commit

Catch

Transaction.Rollback.
 
Hi Herfried,

Why can't the rest of the world be more korrekt!?

Rutsch mir doch den Buckel runter!

;-)

Regards,
Fergus
 
Assigning a transaction to yourAdapater.SelectCommand object's Transaction
property, should be enough.
 
Fergus Cooney said:
Hi Herfried,

Why can't the rest of the world be more korrekt!?

Rutsch mir doch den Buckel runter!

;-)
Click to expand...

What about "You are going me on the alarm clock!" ;-)))
 
Back
Top