private void ButtonСhange_Click(object sender, RoutedEventArgs e) { int idchanged = Convert.ToInt32(id); const string host = "mysql11.hostland.ru"; const string database = "host1323541_itstep6"; const string port = "3306"; const string username = "******"; const string pass = "******"; const string ConnString = "Server=" + host + ";Database=" + database + ";port=" + port + ";User Id=" + username + ";password="******"UPDATE TelephoneBook SET name = '{FirstnameInput.Text}' , surname = '{SurnameInput.Text}' , TelephoneNumber = '{TelephonNamberInput.Text}' WHERE ID = {idchanged};"; var query = new MySqlCommand { Connection = db, CommandText = sql }; var result = query.ExecuteNonQuery(); FirstnameInput.Clear(); SurnameInput.Clear(); TelephonNamberInput.Clear(); if (result == 1) { MessageBox.Show("Данные изменены", "Предупреждение", MessageBoxButton.OK, MessageBoxImage.Information); } else { MessageBox.Show("Данные не изменены", "Предупреждение", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void ButtonUpdate_Click(object sender, RoutedEventArgs e) { ListBox.Items.Clear(); ButtonСhange.IsEnabled = false; Access.IsEnabled = true; FirstnameInput.Clear(); SurnameInput.Clear(); TelephonNamberInput.Clear(); ShowDB(); }
public void FillDummyDataInInputs(string data, string inputName) { switch (inputName) { case "Name": { NameInput.Clear(); NameInput.SendKeys(data); } break; case "Surname": { SurnameInput.Clear(); SurnameInput.SendKeys(data); } break; default: break; } }