示例#1
0
        private void cg_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                CTest test = (CTest)data.SelectedItem;
                adt = new kak(test.nb_field.ToString(), test.fio_field.ToString(), test.ph_field.ToString(), test.mt_field.ToString());

                if (adt.ShowDialog() == true)
                {
                    data.Items.RemoveAt(data.SelectedIndex);

                    string        sql     = "UPDATE test_table SET nb_field = " + adt.nb.Text + ", fio_field = '" + adt.fio.Text + "', ph_field = " + adt.ph.Text + ", mt_field = " + adt.mt.Text + " WHERE nb_field = " + test.nb_field;
                    SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
                    command.ExecuteNonQuery();

                    var d = new CTest {
                        nb_field = int.Parse(adt.nb.Text), fio_field = adt.fio.Text, ph_field = int.Parse(adt.ph.Text), mt_field = int.Parse(adt.mt.Text)
                    };
                    data.Items.Add(d);
                }
            }
            catch (InvalidOperationException)
            {
                MessageBox.Show("Ошибка!");
            }
            catch (FormatException)
            {
                MessageBox.Show("Неверный формат записи!");
            }
            catch (ArgumentNullException)
            {
                MessageBox.Show("Пусто!");
            }
            catch (OverflowException)
            {
                MessageBox.Show("Переполнение!");
            }
            catch (NullReferenceException)
            {
                MessageBox.Show("Выберите элемент!");
            }
            catch (SQLiteException)
            {
                MessageBox.Show("Пусто!");
            }
        }
示例#2
0
        private void add_Click(object sender, RoutedEventArgs e)
        {
            adt = new kak();
            try
            {
                if (adt.ShowDialog() == true)
                {
                    string        sql     = "INSERT INTO test_table (nb_field, fio_field,ph_field,mt_field) VALUES (" + adt.nb.Text + ",'" + adt.fio.Text + "'," + adt.ph.Text + "," + adt.mt.Text + ")";
                    SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
                    command.ExecuteNonQuery();

                    var d = new CTest {
                        nb_field = int.Parse(adt.nb.Text), fio_field = adt.fio.Text, ph_field = int.Parse(adt.ph.Text), mt_field = int.Parse(adt.mt.Text)
                    };
                    data.Items.Add(d);
                }
            }
            catch (InvalidOperationException)
            {
                MessageBox.Show("Ошибка!");
            }
            catch (FormatException)
            {
                MessageBox.Show("Неверный формат записи!");
            }
            catch (ArgumentNullException)
            {
                MessageBox.Show("Пусто!");
            }
            catch (OverflowException)
            {
                MessageBox.Show("Переполнение!");
            }
            catch (SQLiteException)
            {
                MessageBox.Show("Пусто!");
            }
        }