private void RenameChapterForm_FormClosed(object sender, FormClosedEventArgs e) { refFormEditDir.Show(); refFormEditDir.CBoxCh.Text = ""; Array.Clear(refFormEditDir.ThemesList, 0, 49); refFormEditDir.RefreshChapters(); }
private void EditAddChForm_FormClosed(object sender, FormClosedEventArgs e) { refFormEditDir.Show(); refFormEditDir.CBoxTh.Text = ""; refFormEditDir.richTextBox1.Text = ""; refFormEditDir.CBoxTh.Items.Clear(); refFormEditDir.RefreshChapters(); }
private void BYes_Click(object sender, EventArgs e) { if (refFormEditDir.CBoxCh.Text != "") { string tableDelete = Convert.ToString(refFormEditDir.CBoxCh.SelectedItem).Replace(' ', '_').Replace("'", "UC39UC"); using (SQLiteConnection db = new SQLiteConnection("Data Source = Subjects/" + DBName + ".db; Version = 3")) { db.Open(); using (SQLiteCommand cmd = db.CreateCommand()) { cmd.CommandText = "drop table " + tableDelete; using (SQLiteDataReader SQReader = cmd.ExecuteReader()) { for (int i = 0; SQReader.Read(); i++) { refFormEditDir.ChaptersList[i] += SQReader["name"]; refFormEditDir.CBoxCh.Items.Add(refFormEditDir.ChaptersList[i]); } SQReader.Close(); } } db.Close(); } refFormEditDir.CBoxCh.Items.Clear(); refFormEditDir.CBoxCh.SelectedText = ""; refFormEditDir.CBoxCh.Text = ""; refFormEditDir.CBoxTh.Items.Clear(); refFormEditDir.CBoxTh.Text = ""; refFormEditDir.richTextBox1.Text = ""; refFormEditDir.RefreshChapters(); MessageBox.Show("Глава видалена!"); } else { MessageBox.Show("Виберiть главу!"); } this.Close(); }