使用C#来手动连接 Access 2007数据库

  首先新建一个Windows窗体，然后在窗体上拉一个Button控件和一个listbox控件，然后双击Button按钮，再在其双击事件的处理程序中写入其下代码：

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;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //连接数据库
            OleDbConnection con = new OleDbConnection();
            //在Data Source中写明 Access 2007的文件的路径
            con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\pm\\Desktop\\1.accdb";    
            con.Open();
            OleDbCommand cmd = new OleDbCommand();
            cmd.Connection = con;
            cmd.CommandText = "select * from 1";//1是表名
            OleDbDataReader reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                listBox1.Items.Add(reader.GetValue(0));
            }
            reader.Close();
            con.Close();
        }
    }
}