测试Access数据库连接

2015-12-01 15:44:10 访问(1927) 赞(0) 踩(0)



        /// <summary>
        /// 测试Access数据库连接
        /// </summary>
        /// <param name="dbConnectionString"></param>
        /// <returns></returns>
        protected string AccessConnTest(string dbConnectionString)
        {
            string theResult = null;

            OleDbConnection conn = null;
            OleDbCommand cmd = null;

            try
            {
                conn = new OleDbConnection(dbConnectionString);
                conn.Open();

                cmd = new OleDbCommand();
                cmd.CommandText = "select now() as retValue ";
                cmd.CommandType = CommandType.Text;
                cmd.Connection = conn;

                object obj = cmd.ExecuteScalar();

                if (obj != null)
                {
                    theResult = "连接成功，当前数据库时间为：" + obj.ToString();
                }
                else
                {
                    theResult = "连接成功";
                }
            }
            catch (Exception err)
            {
                theResult = "-连接失败，发生异常：" + err.Message;
            }
            finally
            {
                if (cmd != null)
                {
                    cmd.Parameters.Clear();
                    cmd.Dispose();
                    cmd = null;
                }

                if (conn != null)
                {
                    if (conn.State != ConnectionState.Closed)
                    {
                        conn.Close();
                    }

                    conn.Dispose();
                    conn = null;
                }
            }

            return theResult;
        }