private void scheduleButton_Click(object sender, RoutedEventArgs e) { //UPDATE `employeedatabase`.`employeedata` SET `Sunday_Start` = '12' WHERE(`id` = '2'); try { string[] days = { "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday" }; int dbColumn = column + 1; string connectionstring = "SERVER=localhost;DATABASE=employeedatabase;UID=root;PASSWORD=Thisisit123#;"; MySqlConnection connection = new MySqlConnection(connectionstring); MySqlCommand cmd = new MySqlCommand("UPDATE `employeedatabase`.`employeeshift` SET `Shift" + dbColumn.ToString() + "` = '" + this.suggestionID.Text + "' WHERE (`Day` = '" + days[row] + "');", connection); connection.Open(); DataTable dt = new DataTable(); dt.Load(cmd.ExecuteReader()); connection.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } MainWindow win = (MainWindow)Window.GetWindow(this); win.fetch(); win.suggestionStack.Children.Clear(); }