Question

求教一个事务有关问题SqlTransaction已完成;它再也无法使用

Answer 1

求教一个事务有关问题SqlTransaction已完成;它再也无法使用
SqlServerDataBase obj = new SqlServerDataBase();
SqlConnection conn = obj.DBconn();
conn.Open();
SqlTransaction myTrans;
myTrans = conn.BeginTransaction(IsolationLevel.ReadCommitted);

try
{
obj.Insert("insert into StuInfo (StuNumber,Name,Sex,Specialty) values('" + stuNumber + "','" + name + "','" + sex + "','" + specialty + "')", null);
obj.Insert("insert into StuSkill(StuNumber,Skill) values('" + stuNumber + "','" + skill + "')", null);
myTrans.Commit();
Response.Write("两条数据均插入到数据库中！");
}
catch (Exception ex)
{
try
{
myTrans.Rollback();
}
catch (SqlException sqlEx)
{
if (obj.DBconn() != null)
{
Response.Write(sqlEx.GetType()+"数据库打开失败");
Response.Redirect("submit.htm");
}
}
}
finally
{
obj.DBconn().Close();
}