/// <summary>
/// This will remove all chars which are not allowed for the DB and quote / escape when needed
/// </summary>
/// <param name="strTxt">The value to be stored</param>
private static string FilterText(string strTxt)
{
if (string.IsNullOrEmpty(strTxt))
{
return Strings.Unknown;
}
strTxt = strTxt.Replace("'", "''").Trim();
return strTxt;
}
Please report if it's ok or if it failed
Please report if it's ok or if it failed
Can you please send a link?