62,241
社区成员
发帖
与我相关
我的任务
分享一个SqlTransaction 事务的问题
//connection.Open();SqlTransaction st;
.
.
.
try
{
//操作
aa();
st.commit();
}
catch (Exception e)
{
st.Rollback();
return e.message;
}
finally
{
st.Dispose();
}
private void aa()
{
//插入删除修改操作
}
e.message="ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized."
求助，如果方法aa的操作放在try中就不会出现问题，我只想把这个操作放在外面，请问有没方法解决
.
.
.
try
{
//操作
aa();
st.commit();
}
catch (Exception e)
{
st.Rollback();
return e.message;
}
finally
{
st.Dispose();
}
private void aa()
{
//插入删除修改操作
}
e.message="ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized."
求助，如果方法aa的操作放在try中就不会出现问题，我只想把这个操作放在外面，请问有没方法解决
...全文
请发表友善的回复…
发表回复
mjfei 2010-08-25
- 打赏
- 举报
帮顶。
为什么要放外面呢
为什么要放外面呢
wuyq11 2010-08-25
- 打赏
- 举报
Transaction属性尚未初始化
SqlTransaction myTran = con.BeginTransaction();
SqlCommand myCom = new SqlCommand();
myCom.Connection = con;
myCom.Transaction = myTran;
SqlTransaction myTran = con.BeginTransaction();
SqlCommand myCom = new SqlCommand();
myCom.Connection = con;
myCom.Transaction = myTran;
sywcf 2010-08-25
- 打赏
- 举报
你放在外面时，用的是同一个connection吗？
随风落梦 2010-08-25
- 打赏
- 举报
放里面不是更加好嘛，干嘛挪外面啊
