private void BFind_Click(object sender, EventArgs e) { if (TBRussian.Text != "" || TBEnglish.Text != "") { DB.Open(); TBResults.Clear(); SQLiteCommand CMD = DB.CreateCommand(); CMD.CommandText = "select * from Translator where Russian like '%' || @Russian || '%' and English like '%' || @English || '%'"; CMD.Parameters.Add("@Russian", DbType.String).Value = TBRussian.Text.ToUpper(); CMD.Parameters.Add("@English", DbType.String).Value = TBEnglish.Text.ToUpper(); SQLiteDataReader SQReader = CMD.ExecuteReader(); if (SQReader.HasRows) { while (SQReader.Read()) { TBResults.Text += SQReader["Russian"] + " - " + SQReader["English"] + "\r\n"; } } else { TBResults.Text = "Нет результатов"; } LResCount.Text = GetWordsCount(); DB.Close(); } }
private void BDelete_Click(object sender, EventArgs e) { if (TBRussian.Text != "" && TBEnglish.Text != "") { DB.Open(); TBResults.Clear(); SQLiteCommand CMD = DB.CreateCommand(); CMD.CommandText = "delete from Translator where Russian = @Russian and English = @English"; CMD.Parameters.Add("@Russian", DbType.String).Value = TBRussian.Text.ToUpper(); CMD.Parameters.Add("@English", DbType.String).Value = TBEnglish.Text.ToUpper(); CMD.ExecuteNonQuery(); TBRussian.Text = ""; TBEnglish.Text = ""; DB.Close(); RefreshList(); } else { MessageBox.Show("Что бы удалить слово нужно ввести его " + "вариант на двух языках для точного удаления!"); } }
public void RefreshList() { DB.Open(); SQLiteCommand CMD = DB.CreateCommand(); CMD.CommandText = "select * from Translator order by Russian"; TBResults.Clear(); SQLiteDataReader SQReader = CMD.ExecuteReader(); if (SQReader.HasRows) { while (SQReader.Read()) { TBResults.Text += SQReader["Russian"] + " - " + SQReader["English"] + "\r\n"; } } else { TBResults.Text = "Нет результатов"; } LResCount.Text = GetWordsCount(); DB.Close(); }