Access批量执行SQL语句示例

string m_conStr = ConfigurationManager.ConnectionStrings["conStrAccess"].ConnectionString;
    using (OleDbConnection m_cn = new OleDbConnection(m_conStr))
    {
         OleDbCommand m_cmd = new OleDbCommand();
         OleDbTransaction transaction = null;
         m_cmd.Connection = m_cn;
         try
         {
             m_cn.Open();
             transaction = m_cn.BeginTransaction();
             m_cmd.Connection = m_cn;
             m_cmd.Transaction = transaction;
             m_cmd.CommandText = @"update accounts set accounts.account_logintimes = " + 
                                 (int.Parse(GVAccountList.Rows[m_index].Cells[8].Text) + 1) + 
                                 " WHERE accounts.user_id=" + GVAccountList.Rows[m_index].Cells[3].Text + 
                                 " and soft_id=" + GVAccountList.Rows[m_index].Cells[4].Text;
             m_cmd.ExecuteNonQuery();
             OleDbParameter m_soft_id_OleDbParameter = new OleDbParameter();
             m_soft_id_OleDbParameter.DbType = DbType.UInt32;
             m_soft_id_OleDbParameter.ParameterName = "soft_id";
             m_soft_id_OleDbParameter.Value = GVAccountList.Rows[m_index].Cells[4].Text;
             m_cmd.CommandText = @"execute IncreaseSoftLogNum;";
             m_cmd.Parameters.Add(m_soft_id_OleDbParameter);
             m_cmd.ExecuteNonQuery();
             transaction.Commit();
         }
         catch (Exception ex)
         {
             Console.WriteLine(ex.Message);
             try