自己寫的C#對Access操作的資料復原程式

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.OleDb;

using System.Web;

using System.Data.SqlClient;

namespace 資料復原

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        static OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "/data.mdb");

        public void NonReturnDataCommand(params string[] values)

            OleDbCommand cmd = new OleDbCommand("", conn);

            conn.Open();

            OleDbTransaction tran = conn.BeginTransaction();

            cmd.Transaction = tran;

            try

            {

                foreach (string sql in values)

                {

                    cmd.CommandText = sql;

                    cmd.ExecuteNonQuery();

                }

                tran.Commit();

            }

            catch(Exception e)

                tran.Rollback();

                MessageBox.Show(e.ToString(), "錯誤提示", MessageBoxButtons.OK, MessageBoxIcon.Error);

            conn.Close();

        private void button1_Click(object sender, EventArgs e)

            string sqlTran = "insert into B(B1,B2) values(1,555)";

            string sqlNoTran = "insert into A(A1,A2) values(2,666)";

            NonReturnDataCommand( sqlNoTran,sqlTran);

    }

本文轉自黃聰部落格園部落格，原文連結：http://www.cnblogs.com/huangcong/archive/2010/03/26/1697099.html，如需轉載請自行聯系原作者