ZombieCheck

i got this error when try to save a record:
System.InvalidOperationException: This SqlTransaction has completed; it is no longer usable. at System.Data.SqlClient.SqlTransaction.ZombieCheck() at System.Data.SqlClient.SqlTransaction.Rollback() at MediaBuyingCls.addMediaBuyingDirectInter(DataTable dtMbm, DataTable dtMbd, String& mediaOrderNo) at MediaBuyingPress.btnSubmit_Click(Object sender, EventArgs e)
--
Posted via DotNetSlackers.com
Seems like you are doing Rollback after Complete. Is this the case?
Whats your code?
--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
<aichu@.blueocean.net.my> wrote in message
news:eQ%23iFBa%23GHA.924@.TK2MSFTNGP03.phx.gbl...
>i got this error when try to save a record:
> System.InvalidOperationException: This SqlTransaction has completed; it is
> no longer usable. at System.Data.SqlClient.SqlTransaction.ZombieCheck() at
> System.Data.SqlClient.SqlTransaction.Rollback() at
> MediaBuyingCls.addMediaBuyingDirectInter(DataTable dtMbm, DataTable dtMbd,
> String& mediaOrderNo) at MediaBuyingPress.btnSubmit_Click(Object sender,
> EventArgs e)
> --
> Posted via DotNetSlackers.com