public static List<AppSettingData> GetAppSettings()
        {
            List<AppSettingData> list = new List<AppSettingData>();

            try
            {
                string sql = "SELECT setting, value FROM app_settings";

                SQLiteCommand command = new SQLiteCommand(sql, LocalSqllite.m_sqlLiteConnection);
                SQLiteDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    AppSettingData data = new AppSettingData();
                    data.m_setting = reader["setting"].ToString();
                    data.m_value = reader["value"].ToString();

                    list.Add(data);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }

            return list;
        }
        private void AddToDataGridView(AppSettingData data)
        {
            try
            {
                int nNewRow = dataGridView1.Rows.Add();

                dataGridView1.Rows[nNewRow].Cells[0].Value = data.m_setting;
                dataGridView1.Rows[nNewRow].Cells[0].ReadOnly = true;
                dataGridView1.Rows[nNewRow].Cells[0].Style.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold);

                dataGridView1.Rows[nNewRow].Cells[1].Value = data.m_value;
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }