DataAdapter & transation

melvik · February 29th, 2004, 08:08 AM

Hi there:
I have 4 DataAdapter to be apdated!
how can I meke a trasation for there 4 Adapter?!

Code:

Adapter1.Update(dsDabir1);
Adapter2.Update(dsDabir1);
Adapter3.Update(dsDabir1);
Adapter4.Update(dsDabir1);

Tnx in advance.

Always:),
Hovik Melkomian.

bmains · March 3rd, 2004, 05:05 PM

There is a SQLTransaction object that you can use. Using the connection object, you can establish a connection by:

SQLTransaction objTrans = objConnection.BeginTransaction(<Trans params>)

Then passing the transaction to each command object being used.

objCommand.Transaction = objTrans

or in your case

Adapter1.InsertCommand.Transaction = objTrans
Adapter1.UpdateCommand.Transaction = objTrans
Adapter1.DeleteCommand.Transaction = objTrans
...

Then you commit or rollback the transaction upon success/failure.

Brian

melvik · March 4th, 2004, 01:22 AM

Yes I know about

Code:

objConnection.BeginTransaction

but it needs open Connection, but im using SqlAdapter & it handle its connection itself, thats why I asked friends:).

Now after creating objTrans like:

Code:

SQLTransaction objTrans = objConnection.BeginTransaction();

should I set this for all my Adapter Commands?!? How should I use it, Can u give a short sample for my codes, I'll be thankfull.

Always:),
Hovik Melkomian.

Imar · March 4th, 2004, 04:24 AM

I think you said before on another thread that it is "bad practice" to use an explicit connection in combination with a SqlDataAdapter. I don't believe that it is true, and consequently, I don't agree with it.

The Adapter is capable of making sure it has a valid connection; however, there is nothing wrong with creating an explicit connection that you use for one or more dataadapters.

If you take a look here (constructor for an Adapter) you'll see that you can pass in a connection object that is already open. Only you are responsible for closing it again.

So, something like this is perfectly legal and "good practice"

Conn.Open()
// Do whatever you need to do with the connection
// Start a transaction, create and use adapters, whatever
// Continue doing that
Conn.Close()

So, even if the Adapter can handle the connection itself, you can also feed it an existing and open connection.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.