SqlConnection conn = .....
SqlDataAdapter adp = new SqlDataAdapter(cmdText,conn)
trans = conn.BeginTransaction();
....Update
.....trans.Commit()
差不多就这样吧
SqlDataAdapter adp = new SqlDataAdapter(cmdText,conn)
trans = conn.BeginTransaction();
....Update
.....trans.Commit()
差不多就这样吧
System.Data.SqlClient.SqlConnection mCn
=new System.Data.SqlClient.SqlConnection("...");
System.Data.SqlClient.SqlDataAdapter mDa
=new System.Data.SqlClient.SqlDataAdapter("...",mCn);
System.Data.SqlClient.SqlTransaction mTr
=mCn.BeginTransaction();
try
{
//...............
mDa.UpdateCommand.Transaction= mTr;
mDa.Update(...);
mTr.Commit();
}
catch
{
mTr.Rollback();
}
http://blog.csdn.net/xinyulou/archive/2004/06/24/25444.aspx