try
        {
            SQLiteConnection cnn = new SQLiteConnection("DataSource=test.db3");//.s3db");
            cnn.Open();            SQLiteCommand mycommand = new SQLiteCommand(cnn);
            mycommand.CommandText = sql;
            object value = mycommand.ExecuteScalar();
            cnn.Close();
            if (value != null)
            {
                return value.ToString();
            }
        }
        catch (Exception x)
        {
            Console.WriteLine(x.Message);
        }