寫下連接數(shù)據(jù)庫的方法。供新同學學習下

2024-07-21 02:45:02

字體：大中小

供稿：網(wǎng)友

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

        }
        //連接access數(shù)據(jù)庫
        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數(shù)據(jù)庫
        public SqlConnection getConn()
        {
            try
            {
                if (conn == null || conn.State == ConnectionState.Closed)
                {
                    conn = new SqlConnection(strCon);
                }
            }
            catch (Exception e)
            {
                throw e;
            }
            return conn;
        }

    }

本文來自CSDN博客，轉(zhuǎn)載請標明出處：http://blog.csdn.net/yangliuyilovexi/archive/2009/12/17/5027264.aspx

上一篇：基于微軟示例源碼的excel幫助類實現(xiàn),能夠規(guī)避所有的基于oledb模式的缺陷

下一篇：自己寫的一套處理數(shù)據(jù)庫的方法