C#连接数据库

class SqlHelper
    {

        public static string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Environment.CurrentDirectory + "//hy_EProjectLand.accdb;Persist Security Info=False;";

        public SqlHelper()
        {
           
        }

        /// <summary>
        /// 获取数据集
        /// </summary>
        /// <param name="sqlStr"></param>
        /// <returns></returns>
        public static DataSet GetDataset(string sqlStr)
        {
            OleDbConnection connection = new OleDbConnection(connectionString);
            DataSet ds = new DataSet();
            try
            {
                connection.Open();
                OleDbDataAdapter da = new OleDbDataAdapter(sqlStr, connection);
                da.Fill(ds);               
                return ds;
            }
            catch (System.Exception ex)
            {
                return null;
            }
            finally
            {
                connection.Close();
            }
        }

        /// <summary>
        /// 获取数据表
        /// </summary>
        /// <param name="sqlStr"></param>
        /// <returns></returns>
        public static DataTable GetDataTable(string sqlStr)
        {
            OleDbConnection connection = new OleDbConnection(connectionString);
            DataSet ds = new DataSet();
            try
            {
                connection.Open();
                OleDbDataAdapter da = new OleDbDataAdapter(sqlStr, connection);
                da.Fill(ds);               
                if (ds.Tables.Count > 0)
                {
                    return ds.Tables[0];
                }
                else
                {
                    return null;
                }
            }
            catch (System.Exception ex)
            {
                return null;
            }
            finally
            {
                connection.Close();
            }
        }

        /// <summary>
        /// 执行SQL语句
        /// </summary>
        /// <param name="sqlStr"></param>
        /// <returns></returns>
        public static bool Query(string sqlStr)
        {
            OleDbConnection connection = new OleDbConnection(connectionString);
            OleDbCommand cmd = new OleDbCommand(sqlStr, connection);
           
            try
            {
                connection.Open();
                cmd.ExecuteNonQuery();               
                return true;
 
            }
            catch (System.Exception ex)
            {
               
                return false; 
            }
            finally    
            {
                connection.Close();
            }
           
        }
    }