这个程序完成一个事务
public void RunSqlTrans(ArrayList arrlist)
{
Conn_open();
Comm=new SqlCommand();
Comm.Transaction=sqlTra;
sqlTra=Conn.BeginTransaction ();
try
{
for(int i=0;i<arrlist.Count ;i++)
{
Comm.CommandText=arrlist[i].ToString();
Comm.Connection=Conn;
sqlTra=Conn.BeginTransaction ();
Comm.Transaction=sqlTra;
Comm.ExecuteNonQuery();
}
sqlTra.Commit();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
sqlTra.Rollback();
}
finally
{
Conn_close();
}
}
public void RunSqlTrans(ArrayList arrlist)
{
Conn_open();
Comm=new SqlCommand();
Comm.Transaction=sqlTra;
sqlTra=Conn.BeginTransaction ();
try
{
for(int i=0;i<arrlist.Count ;i++)
{
Comm.CommandText=arrlist[i].ToString();
Comm.Connection=Conn;
sqlTra=Conn.BeginTransaction ();
Comm.Transaction=sqlTra;
Comm.ExecuteNonQuery();
}
sqlTra.Commit();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
sqlTra.Rollback();
}
finally
{
Conn_close();
}
}
sqlTra=Conn.BeginTransaction (); 报错为“SqlConnection 不支持并行事务。”
{
sqlTra=Conn.BeginTransaction ();
}
循环开始事务?????????///
{
Conn_open();
sqlTra=Conn.BeginTransaction ();
Comm=new SqlCommand();
Comm.Transaction=sqlTra;
try
{
for(int i=0;i <arrlist.Count ;i++)
{
Comm.CommandText=arrlist[i].ToString();
Comm.Connection=Conn;
//sqlTra=Conn.BeginTransaction ();
//Comm.Transaction=sqlTra;
Comm.ExecuteNonQuery();
}
sqlTra.Commit();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
sqlTra.Rollback();
}
finally
{
Conn_close();
}
}
sqlTra=Conn.BeginTransaction ();
这两句啊
应该是transaction tran=conn.begintransaction()在.NET2.0中有了新的事务了
你可以使用一下,方便多了
using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope())
{
//中间代码 scope.Complete();
}
中间代码失败,自动回滚