C# (CSharp) InteractiveNoticeboard.DB_Manager DBClient.ExecuteScalar Examples

Example #1

        public static string GetSettings(string settings_group, string property)
        {
            string query = string.Format("SELECT val FROM settings WHERE property= '{0}' AND settings_group = '{1}'", property, settings_group);

            return(DBClient.ExecuteScalar(query).GetString());
        }

Example #2

        public static bool HasSettings(string settings_group, string property)
        {
            string query = string.Format("SELECT COUNT(*) AS c FROM settings WHERE property= '{0}' AND settings_group = '{1}'", property, settings_group);

            return(DBClient.ExecuteScalar(query).GetString().ToInt(-1) > 0);
        }