private void AddBN_Click(object sender, RoutedEventArgs e) { try { if (SexCB.Text != "М" && SexCB.Text != "Ж") { return; } string sql = "UPDATE [Employee] SET [SubjectsID] = '" + (SubjectCB.SelectedIndex + 1).ToString() + "', " + "[FIOEmployee] = '" + FIOTB.Text + "', " + "[Sex] = '" + SexCB.SelectedItem.ToString() + "', " + "[DOB] = '" + Convert.ToDateTime(DayB.Text) + "', " + "[Tel] = '" + TelTB.Text + "' " + "WHERE [EmployeeID] = " + UCEmployee.index; WorkWithBD.Update(sql); Close(); } catch { MessageBox.Show("Введите корректные данные"); } }
private void AddBN_Click(object sender, RoutedEventArgs e) { try { DataSet User = new DataSet(); User = WorkWithBD.outPutdb("SELECT StudentID FROM Student WHERE FIO ='" + (FIOCB.SelectedItem).ToString() + "'").Tables[0].DataSet; string idfio = (User.Tables[0].DefaultView[0].Row[0].ToString()); string sql = "UPDATE [Logs] SET [StudentID] = " + idfio + ", " + "[Missed] = '" + ((MissedChB.IsChecked == true)? "н" : " ") + "', " + "[Rating] = " + (RatingCB.SelectedItem.ToString() == " "? "NULL" : RatingCB.SelectedItem.ToString()) + ", " + "[Data] = '" + Convert.ToDateTime(DayB.Text) + "' " + "WHERE [LogsID] = " + UCLogs.index; WorkWithBD.Update(sql); Close(); } catch { MessageBox.Show("Введите корректные данные или проверьте поле оценка"); } }