下面是我程序用到的的事务,vb.net
Dim transCheck As OleDbTransaction = Conn.BeginTransaction
Comm.Connection = Conn
Comm.Transaction = transCheck
Try
......
Dim transCheck As OleDbTransaction = Conn.BeginTransaction
Comm.Connection = Conn
Comm.Transaction = transCheck
Try
......
在用
SqlCommand a2=new SqlCommand("Select * From [Role]",a);
a2.ExecuteReader();
System.Data.SqlClient.SqlTransaction tr;
tr=a.BeginTransaction();
SqlCommand a1=new SqlCommand("Select * From [Position]",a,tr);
SqlDataReader dr = a1.ExecuteReader();
dr.Close(); SqlCommand a2=new SqlCommand("Select * From [Role]",a, tr);
dr = a2.ExecuteReader();
dr.Close();
tr.Commit();
saucer(思归) 已经把代码都写了,我这里补充一下:
执行COMMAND有返回reader ,返回第一行第一列的值和不返回任何值三种,
选用reader时必须创建reader的实例,然后用它来实际的获取数据,用后关闭