c#怎么读取access数据库数据

 我来答

1个回答

#热议# 不吃早饭真的会得胆结石吗？

yinfengnong
2017-11-02 · TA获得超过5619个赞

知道大有可为答主

回答量：2344

采纳率：89%

帮助的人：2391万

我也去答题访问个人页

关注

展开全部

using (OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Data\db.mdb;Persist Security Info=False"))
            {
                conn.Open();
 
                string sql = "SELECT Id,Name,Gender,Birthday,IdentityCode,HomeAddress,EmployeeId FROM tb_employee";
 
                OleDbCommand cmd = new OleDbCommand(sql, conn);
 
                using (IDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        int Id = reader.GetInt32(0);
                                    string Name = reader.GetString(1);
                                    int Gender = reader.GetInt32(2);
                                    DateTime Birthday = reader.GetDateTime(3);
                                    string IdentityCode = reader.GetString(4);
                                    string HomeAddress = reader.GetString(5);
                                    string EmployeeId = reader.GetString(6);
                    }
                }
            }