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"];        }

转载于:https://www.cnblogs.com/befire/archive/2012/04/02/Befire.html