/// <summary> /// Check from database if exist /// </summary> /// <param name="tableName"></param> /// <param name="primaryKeyField"></param> /// <param name="primaryKeyValue"></param> /// <param name="targetFieldName"></param> /// <param name="stringToMatch"></param> /// <returns></returns> public static bool isExist(string tableName, string primaryKeyField, string primaryKeyValue, string targetFieldName, string stringToMatch) { sQuery.Command = @"SELECT * FROM " + tableName + " WHERE " + primaryKeyField + " = '" + primaryKeyValue + "'"; bool result = false; string str1 = "", str2 = ""; str1 = sQuery.getData(tableName, primaryKeyField, primaryKeyValue, targetFieldName); str2 = stringToMatch; if (str1 == str2) { result = true; } else { result = false; } return(result); }