c#连接access学习笔记（一）

在c#中显示access数据库中的数据表：

新建一个winform程序，添加一个dataGridView数据控件，和一个button，添加button的click事件:

private void button1_Click(object sender, EventArgs e)
        {
            //连接指定的ACCESS数据库
            //string connstring = "Provider=Microsoft.Jet.OlEDB.4.0;Data Source=To_Access.mdb";
            OleDbConnectionStringBuilder odcsb=null;
            odcsb.Provider = "Microsoft.Jet.OlEDB.4.0";
            odcsb.DataSource = "To_Access.mdb";
            string connstring = odcsb.ConnectionString;
            //SQL语句
            string sqlstring = "select * from inf_user";
           
            //创建一个OleDBConnection对象
            OleDbConnection oledbconn1 = new OleDbConnection(connstring);
           
            //创建一个DataSet对象
            DataSet dataset1 = new DataSet();
           
            //创建一个OleDbDataAdapter对象
            OleDbDataAdapter dataadapter1 = new OleDbDataAdapter(sqlstring,connstring);
           
            //打开连接
            oledbconn1.Open();

            //通过OleDbDataAdapter对象填充数据集
            dataadapter1.Fill(dataset1,"inf_user");

            //连接数据表格，显示数据
            dataGridView1.DataSource = dataset1.Tables["inf_user"];
        }