sqltransaction using sql helper

[shalini]

hi
friends, I am using execute non querry in sqlhelper . No i want to use
transaction too in
executenonquerr y. sql helper have the overloaded function fortransaction with
sp.
but iam not able to use that. if anyone have used that, then plz tell me how.

i am having the exception login id failed.
code:-

SqlConnection scon = new SqlConnection(g et_connection);
scon.Open();
SqlTransaction sqlTrans = scon.BeginTrans action();
int i = SqlHelper.Execu teNonQuery(sqlT rans, "insertusermst" ,
user_id, user_name, login_id, paassword, User_Status, User_type,
PrAOList_Status , logged_in_user) ;
if (i 0)
{
sqlTrans.Commit ();
}
else
{
sqlTrans.Rollba ck();
}