当前位置：主页 > 技术专题 > 数据库 >

连接数据库的方法

2010-09-27 14:49 作者：admin 来源：admin 浏览次数：

public class DBCon
    {
        PRivate OleDbConnection conn = null;
        private string strCon;
        public DBCon()
        {
            strCon = HttpContext.Current.Server.MapPath("~/Data/test.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;
        }

}

    public class DBCon
    {
        private SqlConnection conn = null;
        private string strCon;
        public DBCon()
        {
            strCon = ConfigurationManager.ConnectionStrings["Connection"].ConnectionString;

        }
        //连接sqlserver2000 或者 2005数据库
        public SqlConnection getConn()
        {
            try
            {
                if (conn == null || conn.State == ConnectionState.Closed)
                {
                    conn = new SqlConnection(strCon);
                }
            }
            catch (Exception e)
            {
                throw e;
            }
            return conn;
        }

    }

上一篇：mysql 数据库卸载不完全，配置出错解决办法
下一篇：最新数据库处理方法