连接access数据库

来源:互联网 发布:嵌入式软件开发薪资 编辑:程序博客网 时间:2024/06/11 04:11

 private OleDbConnection conn = null;
        private string strCon;
        public DBCon()
        {
            strCon = HttpContext.Current.Server.MapPath("~/Data/airwuliu.mdb");

        }
        //连接access数据库
        public OleDbConnection getConn()
        {
            try
            {
                if (conn == null || conn.State == ConnectionState.Closed)
                {
                    conn = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=" + strCon);
                }
            }
            catch (Exception e)
            {
                throw e;
            }
            return conn;
        }
其中~可以获得access数据库的相对路径