sqltransaction using sql helper

[shalini]

hi
friends, I am using execute non querry in sqlhelper . No i want to use
transaction too in
executenonquerry. 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(get_connection);
scon.Open();
SqlTransaction sqlTrans = scon.BeginTransaction();
int i = SqlHelper.ExecuteNonQuery(sqlTrans, "insertusermst",
user_id, user_name, login_id, paassword, User_Status, User_type,
PrAOList_Status, logged_in_user);
if (i 0)
{
sqlTrans.Commit();
}
else
{
sqlTrans.Rollback();
}