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

[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 ...

[Herfried K. Wagner [MVP]]

Hello,

"Joao Santa Barbara" <jo****@i24potugal.com> schrieb:

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

Please do not x-post ADO.NET related questions to the VB.NET language
group.

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
http://www.mvps.org/dotnet

[One Handed Man [ OHM ]]

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

"Herfried K. Wagner [MVP]" <hi*******@m.activevb.de> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Hello,

"Joao Santa Barbara" <jo****@i24potugal.com> schrieb:

hi all i need to work with the commandbuilder and with a transaction

object

how can i do this ????

Please do not x-post ADO.NET related questions to the VB.NET language
group.

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
http://www.mvps.org/dotnet

[Herfried K. Wagner [MVP]]

Hello,

"One Handed Man [ OHM ]" <te***************************@BTOpenworld.com>
schrieb:

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.

I got it for my work in the German language ngs. There are fewer OT
postings than here.

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
http://www.mvps.org/dotnet

[Cor]

Herfried and OHT,

I got it for my work in the German language ngs There are fewer OT
postings than here.

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

[William Ryan]

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.

"Joao Santa Barbara" <jo****@i24potugal.com> wrote in message
news:Oo**************@tk2msftngp13.phx.gbl...

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 ...

[Fergus Cooney]

Hi Herfried,

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

Rutsch mir doch den Buckel runter!

;-)

Regards,
Fergus

[Herfried K. Wagner [MVP]]

Hello,

"Fergus Cooney" <fi******@tesco.net> schrieb:

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

Rutsch mir doch den Buckel runter!

;-)

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
http://www.mvps.org/dotnet

[Marina]

Assigning a transaction to yourAdapater.SelectCommand object's Transaction
property, should be enough.

"Joao Santa Barbara" <jo****@i24potugal.com> wrote in message
news:Oo**************@tk2msftngp13.phx.gbl...

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 ...

[Joao Santa Barbara]

thks
Marina ... for the help .. ;)

"Marina" <nospam> wrote in message
news:e0**************@TK2MSFTNGP12.phx.gbl...

Assigning a transaction to yourAdapater.SelectCommand object's Transaction
property, should be enough.

"Joao Santa Barbara" <jo****@i24potugal.com> wrote in message
news:Oo**************@tk2msftngp13.phx.gbl...

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 ...