By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,891 Members | 1,288 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,891 IT Pros & Developers. It's quick & easy.

sqltransaction using sql helper

P: n/a
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();
}

Jun 27 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.