C# Tutorials and offshore development in India
Tutorials Resources Forum Reviews Communities Interview Jobs Projects Training Videos
Silverlight Games | Mentor | Code Converter | Windows 7 Tools | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop | New Posts


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...


Birthday Greetings 		Learn Windows 7: What are the Technology advancements in on mobile gaming?   This resource will provide information about the advancements that are available in the mobile gaming.



Forums » .NET » ASP.NET »

Error! This SqlTransaction has completed; it is no longer usable. When submittin WEbForm

Posted Date: 17 Aug 2005      Posted By:: Thakar makwana    Member Level: Gold    Member Rank: 0     Points: 2   Responses: 3



Hi,
I can not get any error meg when submit the page but the data not enter in databse and the transaction give this msg.
This SqlTransaction has completed; it is no longer usable
so database not update nad not .trans.rollback().

pls giveme sol.



Responses
Author: swatha     Member Level: Bronze      Member Rank: 0     Date: 18/Aug/2005   Rating: 2 out of 52 out of 5     Points: 2

Can u plz post ur coding here so that i can help u


Bye


Author: swatha     Member Level: Bronze      Member Rank: 0     Date: 18/Aug/2005   Rating: 2 out of 52 out of 5     Points: 2

hi
Most times, the reason you get this error message is because a Database error has occurred, with a severity great enough to force the close of the Database connection.

Try this , if not plz post ur codings so that i can help u.


Author: murali mohan     Member Level: Bronze      Member Rank: 0     Date: 04/Dec/2006   Rating: 2 out of 52 out of 5     Points: 2

Hi,
i got the same error,

in my case, i am doing the insertion in database table using Transaction Class.

Problem is, my database structure is wrong.

The same Query i run in the SQL Query Analyzer, i got the following error.
"Error converting data type varchar to numeric."

I just Changed the Database table structure and tried, Its Ok.

Better do the same process and let us know, if you still can not solve the problem.

-Murali


Post Reply

 This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.
Previous : Validation Controls
Return to Discussion Forum
Post New Message
Category: ASP.NET

About Us    Contact Us    Privacy Policy    Terms Of Use