AccessUtils.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.Common;
using System.Data;
 
namespace be.gaudry.bibliobrol.model.dao.msaccess
{
    /// <summary>
    /// Static methods to use dates into Access SQL request
    /// </summary>
    public static class AccessUtils
    {
        /// <summary>
        /// Gets the formated access date to fill into a SQL request string
        /// </summary>
        /// <param name="dateTime">(DateTime) dateTime to insert</param>
        /// <returns>(String) access SQL formated date string</returns>
        public static String getAccessDate(DateTime dateTime)
        {
            StringBuilder str = new StringBuilder("#");
            str.Append(dateTime.Month);
            str.Append("/");
            str.Append(dateTime.Day);
            str.Append("/");
            str.Append(dateTime.Year);
            str.Append("#");
            return str.ToString();
        }
        /// <summary>
        /// Changes null to empty strings (null values are not allowed in the db) 
        /// and replaces ' by '' to avoid string errors
        /// </summary>
        /// <param name="s"></param>
        /// <returns></returns>
        public static string escapeAndTrim(string s)
        {
            return(s==null)?"":s.Replace("'", "''").Trim();
        }
    }
}