C#操作access数据库

using System;
using System.Collections.Generic;
using System.Text;
using System.Data ;
using System.Data .OleDb ;
using System.Data .SqlClient ;

namespace AutomaticText
{
    class BaseClass
    {
        private static OleDbConnection Con()
        {
            string st = "provider=Microsoft.Jet.OLEDB.4.0;Data Source=diary.mdb;Jet oledb:database password=025715;";

//当数据库没有密码时：Jet oledb:database password=025715不需要
            OleDbConnection con = new OleDbConnection(st);
            return con;
        }
        /// <summary>
        /// 执行查询，返回dataset
        /// </summary>
        /// <param name="sqlsr"></param>
        /// <param name="parameter"></param>
        /// <returns></returns>
        public  static DataSet ExcuteQuery(string sqlsr, OleDbParameter[] parameter)
        {
            using (OleDbConnection con = Con())
            {
                DataSet ds = new DataSet();
                try
                {
                    con.Open();
                    OleDbDataAdapter ada = new OleDbDataAdapter(sqlsr, con);
                    if (parameter != null)
                        ada.SelectCommand.Parameters.AddRange(parameter);
                    ada.Fill(ds);
                    con.Close();
                }
                catch (Exception ex)
                {                   
                    throw ex ;
                }
                return ds;
            }
        }
        public  static DataSet ExcuteQuery(string sqlsr)
        {
            return ExcuteQuery(sqlsr, null);
        }
    }
}