private void button_add_abonent_Click(object sender, EventArgs e) { var form = new AbonentForm(); var res = form.ShowDialog(); if (res == DialogResult.OK) { var surname = form.surname_textbox.Text; var name = form.name_textbox.Text; var patronymic = form.patronymic_textbox.Text; var comment = form.comment_textbox.Text; var address = form.address_textbox.Text; form.dateTimePicker_bd.CustomFormat = "yyyy-MM-dd"; form.dateTimePicker_bd.Format = DateTimePickerFormat.Custom; var birth_day = form.dateTimePicker_bd.Value; var connection = new SqlConnection(connectionString); connection.Open(); var request = @"INSERT INTO Mikolaichuk_Abonent (surname, name, patronymic, address, birth_date, comment) VALUES ('" + surname + "','" + name + "','" + patronymic + "','" + address + "','" + birth_day.ToString("yyyy-MM-dd") + "','" + comment + "')"; var command = new SqlCommand(request, connection); command.ExecuteNonQuery(); connection.Close(); updateAbonentDGV(); updatePhoneHelpDGV(); } }
private void changeabonent_button_Click(object sender, EventArgs e) { var row = abonent_grid.SelectedRows.Count > 0 ? abonent_grid.SelectedRows[0] : null; if (row == null) { MessageBox.Show("Сначала укажите строку!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var form = new AbonentForm(); form.surname_textbox.Text = row.Cells["surname"].Value.ToString(); form.name_textbox.Text = row.Cells["name"].Value.ToString(); form.patronymic_textbox.Text = row.Cells["patronymic"].Value.ToString(); form.address_textbox.Text = row.Cells["address"].Value.ToString(); form.comment_textbox.Text = row.Cells["comment"].Value.ToString(); form.dateTimePicker_bd.Text = row.Cells["birth_date"].Value.ToString(); var res = form.ShowDialog(); if (res == DialogResult.OK) { var surname = form.surname_textbox.Text; var name = form.name_textbox.Text; var patronymic = form.patronymic_textbox.Text; var comment = form.comment_textbox.Text; var address = form.address_textbox.Text; form.dateTimePicker_bd.CustomFormat = "yyyy-MM-dd"; form.dateTimePicker_bd.Format = DateTimePickerFormat.Custom; var birth_day = form.dateTimePicker_bd.Value; var id = row.Cells["id"].Value.ToString(); var connection = new SqlConnection(connectionString); connection.Open(); var request = @"UPDATE Mikolaichuk_Abonent SET surname='" + surname + "', name='" + name + "', patronymic='" + patronymic + "', address='" + address + "'," + " birth_date='" + birth_day.ToString("yyyy-MM-dd") + "', comment='" + comment + "' WHERE id='" + id + "'"; var command = new SqlCommand(request, connection); command.ExecuteNonQuery(); connection.Close(); updateAbonentDGV(); updatePhoneHelpDGV(); } }