[RESOLVED] all or not at all

[met0555]

Hi,

I have the following code,

Try
                SqlDataSource1.Insert() ' SAVE TO DATABASE
                client2.Send(msg2) ' ----EMAIL TO CLIENT 
                client.Send(msg) ' -----EMAIL TO OFFICE
                service.Insert(postUri, entry)
 
            Catch ex As Exception
                Label10.Text = ex.Message
                Label10.ForeColor = Drawing.Color.Red
 
            End Try

I would like to run all the 4 lines of code, or none of them. Is it possible?

thx

[mendhak]

Look up TransactionScope.

Try
   Using scope As New TransactionScope()
 
                SqlDataSource1.Insert() ' SAVE TO DATABASE
                client2.Send(msg2) ' ----EMAIL TO CLIENT 
                client.Send(msg) ' -----EMAIL TO OFFICE
                service.Insert(postUri, entry)
    scope.Complete()
            Catch ex As Exception
                Label10.Text = ex.Message
                Label10.ForeColor = Drawing.Color.Red
 
            End Try

If an error occurs, then scope.Complete isn't called and the transactions are rolled back. However, note that not all parts of your code implement transactions. So if the email sending fails, then your SQL will rollback, but if your service Insert fails, the email cannot be un-sent.

[met0555]

Hi,

There is an error when declaring it as TransactionScope() .
And where shud i put the end using?

thanks

[techgnome]

after the scope.complete

-tg

[gep13]

Hey,

What is the error that you are getting?

Can you post the code as you currently have it?

Gary

[met0555]

Type 'TransactionScope' is not defined.

[gep13]

Hey,

So that suggests that you are missing a using/Imports statement. TransactionScope lives in the System.Transactions namespace, so you will need to include this.

Gary

[met0555]

Still there is a problem after importing it

Namespace or type specified in the Imports 'System.Transactions.TransactionScope' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.

[techgnome]

you import the namespace system.transactions .... TransactionScope is the class... not a namespace, so you do not (cannot) import it.

-tg

[met0555]

Warning 64 Namespace or type specified in the Imports 'System.transactions' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.

[gep13]

Hey,

Can you paste the code that you are using, or at least a screenshot of your code file?

Gary

[techgnome]

Silly question... but did you first REFERENCE System.Transactions? You need to reference it before you can import it.

-tg

[met0555]

good question, i didn't.

it worked now

Thanks

[gep13]

Ha ha, I didn't think to suggest that, assumed that it would have been done

Remember to mark your thread as resolved.

Gary