---------------------------
异常错误
---------------------------
发生异常错误:
System.InvalidOperationException: 此 SqlTransaction 已完成;它再也无法使用。 at System.Data.SqlClient.SqlTransaction.Rollback() at ServiceMS.GUI.ClsDAOHelper.ExecCommandAll(SqlConnection _conn, ArrayList _arrList) in E:\ServiceMS\GUI\ClsDAOHelper.cs:line 302 at ServiceMS.GUI.AppLWF.CtlLWFInfo.SaveAppDoc() in e:\servicems\gui\applwf\ctllwfinfo.cs:line 1216
---------------------------
确定
---------------------------搞了半天没搞定,请各位帮忙。
异常错误
---------------------------
发生异常错误:
System.InvalidOperationException: 此 SqlTransaction 已完成;它再也无法使用。 at System.Data.SqlClient.SqlTransaction.Rollback() at ServiceMS.GUI.ClsDAOHelper.ExecCommandAll(SqlConnection _conn, ArrayList _arrList) in E:\ServiceMS\GUI\ClsDAOHelper.cs:line 302 at ServiceMS.GUI.AppLWF.CtlLWFInfo.SaveAppDoc() in e:\servicems\gui\applwf\ctllwfinfo.cs:line 1216
---------------------------
确定
---------------------------搞了半天没搞定,请各位帮忙。
{
bool bReturn = false;
SqlCommand sqlcom = new SqlCommand();
SqlTransaction sqlTrans = null; try
{
if (_conn.State != ConnectionState.Closed)
{
_conn.Close();
}
_conn.Open();
sqlTrans = _conn.BeginTransaction();
sqlcom.Connection = _conn;
sqlcom.Transaction = sqlTrans;
//多个sqlcomm命令
//sqlcom.ExecuteNonQuery();
sqlTrans.Commit();
}
catch
{
sqlTrans.Rollback();
}
finally
{
_conn.Close();
}
}这是我的代码,急死我了。
请各位帮忙。