Coding Knowledge

public static string CDBStr(string str, bool bIsUnicode) { string strRet = ""; if (str.Length == 0) { return "''"; } else { strRet = "'" + str.Replace("'", "''") + "'"; if (bIsUnicode) { strRet = "N" + strRet; } return strRet; } }