//изменение данных записи в таблице бд по заполненным полям и закрытие формы private void roundBtnChange_Click(object sender, EventArgs e) { using (SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-9IUFQMM\SQLEXPRESS;Initial Catalog=PateticoPractic;Integrated Security=True")) { try { conn.Open(); SqlCommand cmd = conn.CreateCommand(); SqlCommand cmd_1 = conn.CreateCommand(); cmd.CommandText = "UPDATE [Shops] SET address = @Street, time_of_work = @Time WHERE id_shop = @ID"; cmd.Parameters.AddWithValue(@"ID", ShopID); cmd.Parameters.AddWithValue(@"Street", txtForStreet.Text); cmd.Parameters.AddWithValue(@"Time", txtForTime.Text); cmd.ExecuteNonQuery(); MessageBox.Show("Запись успешно изменена!", "Изменение записи"); Shops Shops = new Shops(); Shops.Visible = true; Shops.ShowInTaskbar = true; this.Close(); GC.Collect(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Close(); } } }
//закрытие данной формы и переход к форме списка магазинов private void roundBtnShops_Click(object sender, EventArgs e) { this.Close(); GC.Collect(); Shops Shops = new Shops(); Shops.Visible = true; Shops.ShowInTaskbar = true; }
// добавление записи в БД после заполнения необходимых полей private void roundBtnAdd_Click(object sender, EventArgs e) { if (txtForStreet.Text != "") { using (SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-9IUFQMM\SQLEXPRESS;Initial Catalog=PateticoPractic;Integrated Security=True")) { try { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "INSERT INTO [Shops] VALUES (@street,@time)"; cmd.Parameters.AddWithValue(@"street", txtForStreet.Text); cmd.Parameters.AddWithValue(@"time", txtForTime.Text); cmd.ExecuteNonQuery(); MessageBox.Show("Запись успешно добавлена!", "Добавление записи"); Shops Shops = new Shops(); Shops.Visible = true; Shops.ShowInTaskbar = true; this.Close(); GC.Collect(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Close(); } } } else { MessageBox.Show("Введите адрес магазина!"); txtForStreet.Focus(); } }