c#直连access数据库

不多说了，直接上码。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;

namespace WH
{
    class AccessCZ
    {
        public static string ACCStringec = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\1\\.MDB;User ID=;Jet OLEDB:Database Password="; 
             public static System.Data.DataTable GetDataec(string sql)
            {

                OleDbConnection ACCconn = new OleDbConnection(ACCStringec);
                OleDbCommand  ACCcmd = new OleDbCommand (sql, ACCconn);
                OleDbDataAdapter ACCoda = new OleDbDataAdapter(ACCcmd);                  
                DataTable ACCdtORA = new DataTable();
                ACCdtORA.Clear();
                try
                {
                    ACCconn.Open();
                    ACCoda.Fill(ACCdtORA);
                    return ACCdtORA;
                }
                finally
                {
                    ACCdtORA.Dispose();
                    ACCoda.Dispose();
                    ACCcmd.Dispose();
                    ACCconn.Dispose();
                }
            }

            public static void SaveDataec(string sql)
            {
                OleDbConnection ACCconn = new OleDbConnection(ACCStringec);
                OleDbCommand ACCcmd = new OleDbCommand(sql, ACCconn);
                try
                {
                    ACCconn.Open();
                    ACCcmd.ExecuteNonQuery();
                }
                finally
                {
                    ACCcmd.Dispose();
                    ACCconn.Close();
                    ACCconn.Dispose();
                }
            }

    }
}

使用方法：

 DataTable aa = AccessCZ.GetDataec("select *  from 计量员库");
            dataGridView1.DataSource = aa.DefaultView;