Transactions in .Net

[suki_ash]

Hi

 

I am a new bie to transactions in .Net. I want to maintain transactions in my code.

 

Please see the following pseudo code.

 

public sub update()

{

cmd.Update() 'Update the database

 

createFiles() 'Update the File server by creating some files

 

cmd.Insert() 'Insert some records in the database

 

---------- some more code

}

 

Now, here i need to maintain the transaction scope in the method update().

 

Whereever it got a problem in this method, it should be rolled back.

 

I tried the TransactionScope in .Net framework 2.0 but it seems like not working.

 

Please suggest me some way to do this.

 

Thanks in advance,

Subhash.

[georgepatotk]

what database u are using?

 

if i am using mysql,

i would set AUTO COMMIT

[amir100]

How about using the BeginTransaction method from the Connection object. If your database support transaction then you can handle commit and rollback in your application.

 

CMIIW.