Replace Single Quote (') with Double Single Quotes ('')
ReplaceSingleQuote
Replace Single Quote (') with Double Single Quotes ('')
/// <summary>
/// Replace Single Quote (') with Double Single Quotes ('')
/// </summary>
/// <param name="value">string to replace</param>
/// <returns>string</returns>
public static string ReplaceSingleQuote( string value )
{
if ( !string.IsNullOrEmpty( value ) )
{
return value.Replace( "'" , "''" );
}
return value;
}