public class DbHelperOleDb

    {

        private string connectionString = string.Empty;

        public DbHelperOleDb(string conn)

        {

            connectionString = conn;

        }



        #region  执行简单SQL语句



        /// <summary>

        /// 执行SQL语句，返回影响的记录数

        /// </summary>

        /// <param name="SQLString">SQL语句</param>

        /// <returns>影响的记录数</returns>

        public int ExecuteSql(string SQLString)

        {

            using (OleDbConnection connection = new OleDbConnection(connectionString))

            {

                using (OleDbCommand cmd = new OleDbCommand(SQLString, connection))

                {

                    try

                    {

                        connection.Open();

                        int rows = cmd.ExecuteNonQuery();

                        return rows;

                    }

                    catch (System.Data.OleDb.OleDbException E)

                    {

                        connection.Close();

                        throw new Exception(E.Message);

                    }

                }

            }

        }



        #endregion