access 的连接

<add key="DriverDB" value="Provider=Microsoft.Jet.OLEDB.4.0;persist security info=false;Jet OLEDB:Database Password=;data source="/>
  <add key="PathDB" value="~/MyDBles.mdb"/>
-------------------------------------------------连接数据库

 ----------------------------------------------------------------------------------查询
         DealerModel.Admin SearchAdmin(string name, string pwd)
        {
            string sql = "select USER_ID,name,login_count,last_login_time,role_id from ZR_ADMIN_USER where USER_ALIAS = @name and password = @pwd ";
            OleDbParameter[] par = new OleDbParameter[]{
                new OleDbParameter("@name",name),
                new OleDbParameter("@pwd",pwd)
            };
           
            OleDbDataReader dr = DBHelper.ExecuteReaderm(GetConnection.GetCon(), CommandType.Text, sql, par);
            List<DealerModel.Admin> ads = GetObj(dr);
            dr.Close();
            if (ads.Count > 0)
            {
                DealerModel.Admin ad = ads[0];
                return ad;
            }
            return null;
        }