asp.net中怎么使用事务
asp.net中怎么使用事务

------解决方案--------------------
SqlTransaction trans = Conn.BeginTransaction();
这是SQL本地事务，ODBC，OLEDB同
分布事务，可以去参考一下
http://blog.csdn.net/honkerhero
------解决方案--------------------
SqlTransaction st= conn.BeginTransaction();
st.Commit();//提交
st.Rollback();//回滚
------解决方案--------------------
SqlTransaction st= conn.BeginTransaction();
try
{
st.Commit();//提交
}
ctach()
{
st.Rollback();//回滚
}
------解决方案--------------------
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings[ "ConnectionString "]);
SqlCommand cmd=new SqlCommand();
cmd.Connection=conn;
conn.Open();
SqlTransaction tran=conn.BeginTransaction();//定义事务对象
cmd.Transaction=tran;
try
{
cmd.CommandText= "update areaSort set orderid= "+uporderid+ " where id= "+id.ToString();
cmd.ExecuteNonQuery();
cmd.CommandText= "update areaSort set orderid= "+oldorderid+ " where id= "+upid;
cmd.ExecuteNonQuery();
tran.Commit();
conn.Close();
}
catch
{
tran.Rollback();
conn.Close();
}
上述只要有一个cmd没有成功，则会退回原始状态。