C#中连接ACCESS数据库的方法

命名空间引用：

using System.Data.OleDb;
using System.Data;

建立连接：

        private OleDbConnection Getconnection()//建立连接
        {
            //string Constr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Administrator\Documents\测试.accdb";
 string path_startup = System.Windows.Forms.Application.StartupPath;// +@"\Data\测试.accdb";
           string path_startup = System.Windows.Forms.Application.StartupPath;// +@"\Data\测试.accdb";
            string Constr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path_startup + @"\Data\测试.accdb";//当前文件下的路径
 
            OleDbConnection myCon = new OleDbConnection(Constr);
            return myCon;
        }

连接DataGridView ：

private void query_CX(DataGridView dt)//查询语句
        {
            OleDbConnection myCon = Getconnection();
            try
            {
                myCon.Open();
                string sql = "select * from 表1";
                OleDbDataAdapter myda = new OleDbDataAdapter(sql, myCon);
                DataSet myds = new DataSet();
                myda.Fill(myds, "表1");
                dt.DataSource = myds.Tables[0];
            }
            catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); }
            finally
            {
                myCon.Close();
            }
        }

加载事件中调用查询命令：

   private void Form1_Load(object sender, EventArgs e)
        {
            query_CX(dataGridView1);//查询语句
        }

Command命令删除操作：

OleDbConnection myCon = Getconnection();
            myCon.Open();
            string sql_detele = "select * from 表1 where id=" + textBox1.Text;
            try
            {
                OleDbCommand myCom = new OleDbCommand(sql_detele, myCon);
                myCom.ExecuteNonQuery();
            }
            catch (Exception ex) { System.Diagnostics.Debug.Write(ex.ToString()); }
            finally
            {
                myCon.Close();
            }

筛选命令：

OleDbConnection myCon = Getconnection();
            myCon.Open();
            string sql_filter = "select * from 表1 where id=" + textBox1.Text;
            try
            {
                OleDbDataAdapter myda = new OleDbDataAdapter(sql_filter, myCon);
                DataSet myds = new DataSet();
                myda.Fill(myds, "表1");
                dataGridView1.DataSource = myds.Tables[0];
            }
            catch (Exception ex) { System.Diagnostics.Debug.Write(ex.ToString()); }
            finally
            {
                myCon.Close();
            }