C#如何操作access資料庫

在program.cs的main函數中寫下如下代碼：

static void Main()

        {

            string dataDir = AppDomain.CurrentDomain.BaseDirectory;

            if (dataDir.EndsWith(@"\bin\Debug") || dataDir.EndsWith(@"\bin\Release\"))

            {

                dataDir = System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName;

                AppDomain.CurrentDomain.SetData("DataDirectory", dataDir);

            }

            Application.EnableVisualStyles();

            Application.SetCompatibleTextRenderingDefault(false);

           // Application.Run(new FrmInport());

            Application.Run(new InExport());

        } 

在ClassDataBase.cs中寫入如下代碼

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data.OleDb;

using System.Data;

namespace WindowsFormsApplication

{

    class ClassDataBase

    {

        static public string connString = "Provider = Microsoft.jet.OLEDB.4.0;Jet OLEDB:Database [email protected] x%E$ ^GF;Data Source =Database/SSQDYJ.mdb";

        static public OleDbConnection  openDatabaseConn() //打開Access資料庫連接配接

        {

            OleDbConnection myconn=new OleDbConnection(connString);

            myconn.Open();

             //Error: value="~/Database/SSQDYJ.mdb"   //多餘了“~/”字元

            //'F:\WindowsFormsApplication\WindowsFormsApplication3\WindowsFormsApplication3\bin\Debug\~\Database\SSQDYJ.mdb'

            //不是一個有效的路徑。 确定路徑名稱拼寫是否正确，以及是否連接配接到檔案存放的伺服器。           

            return  myconn;

        }

        static public void CloseConn(OleDbConnection myconn)//關閉Access資料庫連接配接

        {

            if (myconn.State == ConnectionState.Open)

            {

                myconn.Close();

                myconn.Dispose();

            }

        }

        //        Command指令

        // 傳回值        

        //ExecuteReader        // 傳回一個 DataReader 對象        

        //ExecuteScalar        // 傳回一個标量值        

        //ExecuteNonQuery      // 執行不傳回任何行的指令        

        //ExecuteXMLReader     // 傳回 XmlReader。 隻用于 SqlCommand 對象

        static public DataTable CommandSql(OleDbConnection myconn, string sql,params string[] filedsValue)

        {

            if (myconn.State == ConnectionState.Closed) myconn.Open();

            OleDbCommand myCommand = new OleDbCommand(sql ,myconn);

            OleDbDataAdapter myAdapter = new OleDbDataAdapter(myCommand);

            DataSet myDataset = new DataSet();

            myAdapter.Fill(myDataset);

            CloseConn(myconn);

            return myDataset.Tables[0];

        }

    }

}

在調用的頁面InExport寫如下代碼：

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Data.OleDb;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

namespace WindowsFormsApplication3

{

    public partial class InExport : Form

    {

        static public OleDbConnection myconn=new OleDbConnection(); //定義全局變量

        public InExport()

        {

            InitializeComponent();                

            openOleconn();

            MessageBox.Show(Convert.ToString(myconn.State));

            MeeBox();

            MessageBox.Show(Convert.ToString(myconn.State));

        }

        public void MeeBox()

        {

            DataTable myTable = ClassDataBase.CommandSql(myconn, "select top 20 * from Fl_Issue order by LotIssue desc");

            MessageBox.Show(Convert.ToString( myTable.Rows.Count));

        }

        public void openOleconn()

        {

            myconn = ClassDataBase.openDatabaseConn();

            //MessageBox.Show(Convert.ToString( myconn.State));

            //ClassDataBase.CloseConn(myconn);

            //MessageBox.Show(Convert.ToString(myconn.State));

        }

        private void InExport_Load(object sender, EventArgs e)

        {

            DataView dv = new DataView();

            Control cr = new Control("顯示一個控件");

        }

    }

}