private void updateRemState(int state) { btnGood.Checked = (state == 1); btnBad.Checked = (state == 2); SQLiteCommand cmd = new SQLiteCommand("UPDATE words SET `state`=@state WHERE `id`=@id", Gib.con); cmd.Parameters.AddWithValue("@state", state); cmd.Parameters.AddWithValue("@id", words[cur].id); cmd.ExecuteNonQuery(); Gib.Word item = words[cur]; item.state = state; words[cur] = item; refreshGoodBadCount(); }
public void getWordList() { SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM words WHERE `group`=@group", Gib.con); // ORDER BY `word` cmd.Parameters.AddWithValue("@group", Gib.curGroup); SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Gib.Word item = new Gib.Word(); item.id = Convert.ToInt32(reader["id"]); item.word = reader["word"].ToString(); item.trans = reader["trans"].ToString(); item.state = Convert.ToInt32(reader["state"]); words.Add(item); } }