Hi,
I am getting this error message
"This SqlTransaction has completed; it is no longer usable"
What's really strange is that I am getting this error from a page where I am not even using SqlTransaction.
How can I find the root cause and solve this problem?
Help Please!
updatestring = "Update [Flow] set received=1 where flowid=@flowid"
insertstring = "Insert into [Flow] (barcode, copyid, floworder, recvdate, recvuser, recvdepartment) "
insertstring += "values (@barcode, @copyid, @floworder, @recvdate, @recvuser, @recvdepartment)"
is it can't use sqltransaction in the same table ???
when i not apply the sqltransaction, then the about two queries can work success, but when i apply the sqltransaction, then have an error in following.
error :
Object reference not set to an instance of an object
Source Error:
Line 278: message.Text = "Recebido o documento " & barcodetx.Text & "!!"
Line 279: Catch ex As Exception
<red>Line 280: objtransaction.Rollback()</red>
Line 281: message.Text = "Não se conseguiu registar!!"
Line 282: Finally
hi,Is it over head to use SqlTransaction(begin, commit, rollback) for a single transaction.am not using application block or enterprise library.only a single insert statement.
View 3 Replies View RelatedHi,
I use SqlTransaction to add record to the database. But I got a warning message on the "objTransact.Rollback()" that said "Variable 'objTransact' is used before it has been assigned a value, A null reference exception could result at runtime". what does this mean? how can I fix it? The following is the code. Thanks.
---------------------------------------------------------------------------------
Dim objTransact As SqlTransaction
Try
objConnect.Open()
objTransact = objConnect.BeginTransaction()
cmd.Connection = objConnect
cmd.Transaction = objTransact
-----do some sql query here............
objTransact.Commit()
Catch objError As Exception
objTransact.Rollback()
Finally
objConnect.Close()
End Try
Hi,
I am getting the below error when using the SqlTransaction's for doing DML operations for different tables,
"System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
Thanks in advance.
With regards,
Mani
Hello,
I want to know, if you can use SqlTransaction even if you only execute one statement/query? I am particularly interested in Rollback(), which is called when the user presses the cancel button to abort a long file transfer.
Does rollback immediatley cancel the transfer and return control? Or, what is the best way of implementing a cancel option for transferring data?
Thank you
I have a class which has connection, transaction object and BeginTransaction of that method opens the transaction. This class has an array of objects of a base class which refers to their derived classes at runtime and passes the reference of connection and transaction object to the derived class. Now from the main class I call BeginTransaction and then from any of the array element some insert update will be called using the same connection and transaction which has been opened from parent class.
I get the following exception while executing the sql statement in the method of derived class
Unhandled Exception: System.InvalidOperationException: ExecuteNonQuery requiresthe command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized. at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
I tried using isolation level but transaction control does not work. I can not change the design...
I want to know if it's a good practice to use sql-transaction in both c# and sql procedures code.
View 4 Replies View RelatedHi All,I am using a SQLTransaction to insert records into a table. At onetime, there are 5000 or more records to be inserted one by one. Ittakes some 20-25 mins for the entire process to run.Another application accesses the same table.As long as the insert process within the transaction isn't completed,the second application is not getting any response from the server. Ieven tried to run a SELECT on the table in SQL Query Analyzer while theinsert process was running and it also did not respond till the timethe insert process finished!Is this normal that a transaction is locking up a table? How do Iovercome it? I am using IsolationLevel.ReadUncommitted for thetransaction.If I do not run the process within a SQLTransaction, the second processor running the SELECT in Query Analyzer does not hang.Thanks,Sanjeev Mahajan
View 3 Replies View RelatedHi,
So I'm having an issue with a SqlTransaction and retrieving the auto-increment ID after an insert. Presumably this is because I have to commit the transaction before the ID's are generated, but I need the ID's before I commit the transaction (because their is another part of the transaction that requires them).
Is there any way to get these id's other than maybe getting the Max(ID) and auto-incrementing them myself in code to what they will be when the transaction is committed. If this is the best way how do I ensure no other connections can insert stuff while this transaction is going on?
Or is there a better way to do this whole thing? (i don't know really know how to do stored procedures, and presumably this would be the best way, but is there a good way to do it not Stored Procedures)
Thanks!
can anyone tell me what is the origin of this error "This SqlTransaction has completed; it is no longer usable".
View 2 Replies View RelatedHello,I am trying to begin a transaction is ASP.NET that acts as a temporary lock on a record so that another web user can not gain access to that row of information. My problem is that when I begin the transaction, if the user then closes out of the browser completely, the temporary lock that is put on my table from the transaction does not go away. Further, I have no idea if it will or if there is a time range you can specifiy to do so.What I am wondering is if anyone has ever tried this before, or does anyone have a definite answer to the following question, "If I begin a transaction, and then I do NOT rollback or committ that transaction, will it ever rollback on its own and if so where can I set this time frame?"Thanks in advance for any help.
View 3 Replies View RelatedHi,
I want to make SQLTransaction as global and use it checking the State.
But then where there are Only Select queries are going to fire, it will open transaction.
So, Does it locks database/tables when Only Select query comes in SQLTransaction.
If you have another successful way of doing this, Please suggest.
Thanking you.
tats