sqltransaction

See more:

ASP.NET

Hai all,

I am using transaction in my asp.net2.0 web page.

Can I use a seperate sqlstatement to fetch some value in between tran.open and trans.commit other than transaction statements.

I have used samething in asp.net 1.1 and it is working perfectly.
But in 2.0 it is giving an error saying "this transaction is completed" and it is no more usable.

Ex:

sqlconn.Open()
                   Try 
                       myTrans = sqlconn.BeginTransaction()
                       s1.Connection = sqlconn
                       s1.Transaction = myTrans
                       s1.CommandText ="insert statement"
                        s1.ExecuteNonQuery()

Here i wanted to use a select statement which will fetch some value from databae which am using in my update statement by opening and closing a db connection.
this phenomena is working in .net 1.1 and giving the said error in .net 2.0

s1.CommandText ="some update statement"
                     s1.ExecuteNonQuery()
                     myTrans.Commit()
                   Catch ex As Exception
                       myTrans.Rollback()
                       mb.ShowMessagebox(Page, ex.Message)
                   Finally
                       sqlconn.Close()
                   end try

if somebody knows the solution please let me know.
thanks in advance