Method to format the input string

   /// <summary>
        /// format the input string;
        /// </summary>
        /// <param name="inputString"></param>
        /// <returns></returns>
        public static string FormatInputString(string inputString)
        {
            return "'" + inputString.Trim().Replace("'", "''") + "'";
        }