记录一下WPF开发（二）--- access数据库DAL

直奔主题....

有时候桌面小程序用Access数据库是非常方便的，SQlHelper.cs如下

class SqlHelper
    {
        //获取数据库存放路径
        private static string path = Environment.CurrentDirectory + "/DB/Pump.mdb";
        private static String connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Jet OLEDB:Database Password=sql;";

        /// <summary>
        /// 执行增(insert)、删(delete)、改(update)的方法
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="parameters"></param>
        /// <returns></returns>
        public static int ExecuteNonQuery(String sql, params OleDbParameter[] parameters)
        {
            using (OleDbConnection conn = new OleDbConnection(connStr))
            {
                conn.Open();
                using (OleDbCommand cmd = conn.CreateCommand())