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); } }