• C# access数据库软件使用事务插入多条记录


    C# access数据库软件使用事务插入多条记录
      protected void Button1_Click(object sender, EventArgs e)
      {
      /*=============测试通过===============*/
      OleDbConnection con = new
      OleDbConnection(“Provider=Microsoft.Jet.OleDb.4.0;Da
      ta
      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();
      }
      }

  • 相关阅读:
    捕捉整个桌面的图片
    在Image控件中绘制文字
    绘图
    Image1.Canvas画图笔刷
    将图片序列保存为GIF文件
    拷贝剪贴板图像到窗体
    显示 png 图片
    将图片以字符串方式保存
    复制图片的一部分
    反转字符串
  • 原文地址:https://www.cnblogs.com/FLWL/p/3900524.html
Copyright © 2020-2023  润新知