I am getting this erroor on transaction.commit
"stack overflow"

on transaction.rollback i am getting this
{"This SqlTransaction has completed; it is no longer usable." }

I am passing same transaction object to lot of methods like say 12
which call stored procedures

how to overcome this problem.

I dont want to use com+

Thanks
Ajit

i guess you are invoking begintransaction too many times?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
SLODUG - Slovene Developer Users Group www.codezone-si.info

"ajit" <(E-Mail Removed)> wrote in message
news:C98FD3F2-14CF-4496-A9D6-(E-Mail Removed)...
>I am getting this erroor on transaction.commit
> "stack overflow"
>
> on transaction.rollback i am getting this
> {"This SqlTransaction has completed; it is no longer usable." }
>
> I am passing same transaction object to lot of methods like say 12
> which call stored procedures
>
> how to overcome this problem.
>
> I dont want to use com+
>
> Thanks
> Ajit

No I am not I am doing something like this



Re: ado.net transactions
Posted: 02-14-2005 10:04 AM
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();

using (SqlTransaction transaction = connection.BeginTransaction())

{

try
{
using (INASBAL.Service service = new INASBAL.Service())
{




service.SequenceID = service.InputAccountData(transaction, ref dt);

ParseAndInsertAccountLeadType(transaction, ref dt, nav, service);


ParseAndInsertAccountDisabilityCoverage(transaction, ref dt, nav, service);


ParseAndInsertAccountAuthorizedRider(transaction, ref dt, nav, service);


ParseAndInsertMailingAddress(transaction, ref dt, nav, service);


ParseAndInsertAccountAgent(transaction, ref dt, nav, service);


ParseAndInsertAccountAuthorizingOfficer(transaction, ref dt, nav, service);

ParseAndInsertAccountBillingContact(transaction, ref dt, nav, service);
ParseAndInsertAccountBroker(transaction, ref dt, nav, service);
ParseAndInsertAccountFlexOneBenefit(transaction, ref dt, nav, service);
ParseAndInsertAccountLegalRep(transaction, ref dt, nav, service);
ParseAndInsertAccountContactFsa(transaction, ref dt, nav, service);
ParseAndInsertAccountFlexIneligibleBen(transaction, ref dt, nav, service);


ParseAndInsertAccountOtherCarrierBen(transaction, ref dt, nav, service);

//
//if all successful commit transaction
//
transaction.Commit();

}//using service

}//try

catch (Exception ex)
{
transaction.Rollback();
throw ex;
}

}//using transaction

}//using connection


INSIDE THESE METHODS I AM USING MS DATA APPLICATION BLOCK LIKE

Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(transaction,
CommandType.StoredProcedure, strProcedure, arParms);


Thanks
Ajit

"Miha Markic [MVP C#]" wrote:

> i guess you are invoking begintransaction too many times?
>
> --
> Miha Markic [MVP C#] - RightHand .NET consulting & development
> www.rthand.com
> SLODUG - Slovene Developer Users Group www.codezone-si.info
>
> "ajit" <(E-Mail Removed)> wrote in message
> news:C98FD3F2-14CF-4496-A9D6-(E-Mail Removed)...
> >I am getting this erroor on transaction.commit
> > "stack overflow"
> >
> > on transaction.rollback i am getting this
> > {"This SqlTransaction has completed; it is no longer usable." }
> >
> > I am passing same transaction object to lot of methods like say 12
> > which call stored procedures
> >
> > how to overcome this problem.
> >
> > I dont want to use com+
> >
> > Thanks
> > Ajit
>
>
>