下面代码是写入数据库记录,
public void Insert(string DepID, string DepName, string DepMemo)
{
IDbConnection db = null;
IDbTransaction mTransaction = null;
try
{
db = DataAccess.Connection.CreateConnection();
mTransaction = db.BeginTransaction(IsolationLevel.ReadCommitted);
IDbCommand mCommand = db.CreateCommand();
mCommand.CommandText = "insert into department(dep_id,dep_name,dep_memo) values(@dep_id,@dep_name,@dep_memo)";
IDbDataParameter mParam;
mCommand.Parameters.Clear();
mParam = mCommand.CreateParameter();
mParam.ParameterName = "@dep_id";
mParam.Value = DepID;
mCommand.Parameters.Add(mParam); mParam = mCommand.CreateParameter();
mParam.ParameterName = "@dep_name";
mParam.Value = DepName;
mCommand.Parameters.Add(mParam); mParam = mCommand.CreateParameter();
mParam.ParameterName = "@dep_memo";
mParam.Value = DepMemo;
mCommand.Parameters.Add(mParam);
mCommand.ExecuteNonQuery();
mTransaction.Commit();
}
catch(Exception e)
{
if (mTransaction != null)
mTransaction.Rollback();
throw(e);
}
finally
{
if (db != null)
db.Close();
}
} 这个怎么执行的时候提示错误了
提示TRANSACTION属性尚未初始化?
public void Insert(string DepID, string DepName, string DepMemo)
{
IDbConnection db = null;
IDbTransaction mTransaction = null;
try
{
db = DataAccess.Connection.CreateConnection();
mTransaction = db.BeginTransaction(IsolationLevel.ReadCommitted);
IDbCommand mCommand = db.CreateCommand();
mCommand.CommandText = "insert into department(dep_id,dep_name,dep_memo) values(@dep_id,@dep_name,@dep_memo)";
IDbDataParameter mParam;
mCommand.Parameters.Clear();
mParam = mCommand.CreateParameter();
mParam.ParameterName = "@dep_id";
mParam.Value = DepID;
mCommand.Parameters.Add(mParam); mParam = mCommand.CreateParameter();
mParam.ParameterName = "@dep_name";
mParam.Value = DepName;
mCommand.Parameters.Add(mParam); mParam = mCommand.CreateParameter();
mParam.ParameterName = "@dep_memo";
mParam.Value = DepMemo;
mCommand.Parameters.Add(mParam);
mCommand.ExecuteNonQuery();
mTransaction.Commit();
}
catch(Exception e)
{
if (mTransaction != null)
mTransaction.Rollback();
throw(e);
}
finally
{
if (db != null)
db.Close();
}
} 这个怎么执行的时候提示错误了
提示TRANSACTION属性尚未初始化?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货