public BD()
{
InitializeComponent();
try
{
ConnectionDB.ConnectToDataBase();
DataTable dt = new DataTable("Calificaciones");
OleDbCommand cmd = ConnectionDB.DisplayTableValues();
cmd.ExecuteNonQuery();
OleDbDataAdapter oleDb = ConnectionDB.DisplayTable();
oleDb.Fill(dt);
dtgCalificacion.ItemsSource = dt.DefaultView;
oleDb.Update(dt);
}
catch (Exception ex)
{
var error = ex.Message;
//Operador Ternario; es igual a utilizar un if y un else
MessageBox.Show((ex is SqlException) ? ($"SQL error is: {error}!") : ($"Unexpected Error: {error}!"), "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
finally
{
ConnectionDB.DisconnectDataBase();
}
}
