关于多库操作一些想法

        /// <summary>
        /// 功能描述:sql连接方法
        /// </summary>
        /// <returns>如果存在，返回数据库集</returns>
        public static SqlConnection Sql()
        {
            SqlConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconfig"].ToString());
            try
            {
                db.Open();
                return db;
            }
            catch (Exception ex)
            {
                return null;
            }
        }

        /// <summary>
        /// 功能描述:SqlDataReader 方法
        /// </summary>
        /// <param name="str">查询数据</param>
        /// <returns>返回一个数据集</returns>
        public static SqlDataReader sdr(string str)
        {
            SqlConnection sql = sdb.Sql();
            SqlCommand cmd = new SqlCommand(str, sql);
            SqlDataReader sdr = cmd.ExecuteReader();
            return sdr;
        }


/// <summary>
        /// 功能描述:odbc连接方法
        /// </summary>
        /// <returns>如果存在，返回数据库集</returns>
        public static OleDbConnection odbc()
        {
            OleDbConnection odb = new OleDbConnection(ConfigurationManager.ConnectionStrings["dbconfig"].ToString());
            try
            {
                odb.Open();
                return odb;
            }
            catch (Exception ex)
            {
                return null;
            }
        }

        /// <summary>
        /// 功能描述:OleDbDataReader 方法
        /// </summary>
        /// <param name="str">查询数据</param>
        /// <returns>返回一个数据集</returns>
        public static OleDbDataReader oddr(string str)
        {
            OleDbConnection odb = oldb.odbc();
            OleDbCommand cmd = new OleDbCommand(str, odb);
            OleDbDataReader oddr = cmd.ExecuteReader();
            return oddr;
        }



上面一种是SQL库的简单操作方法，一中是ODBC的操作方法（一般用来操作ACCESS库）