access事务插入多条记录

 

protected void Button1_Click(object sender, EventArgs e)
    {
        /*=============测试通过===============*/
        OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:/Inetpub/wwwroot/DotNetArticle/App_Data/DotNetArticle.mdb");
        con.Open(); 

        OleDbCommand cmd = new OleDbCommand();
        cmd.Connection = con;
        cmd.Transaction = con.BeginTransaction();
        try
        {
            string sql1 = "insert into teaminfo (num,username,isplay) values(1,'a',1)";
            string sql2 = "insert into teaminfo (num,username,isplay) values(2,'b',1)";
            string sql3 = "insert into teaminfo (num,username,isplay) values(3,'c',1)";

            string[] SQLStringList = { sql1, sql2, sql3 };
            for (int n = 0; n < SQLStringList.Length; n++)
            {
                string strsql = SQLStringList[n].ToString();
                if (strsql.Trim().Length > 1)
                {
                    cmd.CommandText = strsql;
                    cmd.ExecuteNonQuery();
                }
            }          
            cmd.Transaction.Commit();  //提交事务
            Response.Write("OK");

        }
        catch (Exception)
        {
            cmd.Transaction.Rollback();
        }
        finally
        {
            con.Close();
        }
    }

转载自：https://www.cnblogs.com/gdjlc/archive/2009/11/10/2086946.html