private void AllDataMenuItem_Click(object sender, RoutedEventArgs e) { if (!DBUtils.IsAvailable()) { HideAllTabs(); MessageBox.Show("Для даного действия нужно подключение к серверу MySQL.\nПодключитесь к ссерверу используя \"Подключить к БД\" главного меню.", "Ошибка"); return; } HideAllTabs(); StudentTabItem.Visibility = Visibility.Visible; GroupsTabItem.Visibility = Visibility.Visible; DiscipleTabItem.Visibility = Visibility.Visible; FacultyTabItem.Visibility = Visibility.Visible; N_NTabItem.Visibility = Visibility.Visible; StudentTabItem.IsSelected = true; StudentDG.Items.Clear(); GroupsDG.Items.Clear(); DiscipleDG.Items.Clear(); FacultyDG.Items.Clear(); Stud_GroupDG.Items.Clear(); Group_DiscDG.Items.Clear(); List <Student> DataList1 = new List <Student>(); string strQuery = "select * from Student"; DBUtils.GetFromDB(DataList1, strQuery); foreach (Student stud in DataList1) { StudentDG.Items.Add(stud); } List <Groups> DataList2 = new List <Groups>(); strQuery = "select * from Groupz"; DBUtils.GetFromDB(DataList2, strQuery); foreach (Groups group in DataList2) { GroupsDG.Items.Add(group); } List <Disciple> DataList3 = new List <Disciple>(); strQuery = "select * from Disciple"; DBUtils.GetFromDB(DataList3, strQuery); foreach (Disciple disc in DataList3) { DiscipleDG.Items.Add(disc); } List <Faculty> DataList4 = new List <Faculty>(); strQuery = "select * from Faculty"; DBUtils.GetFromDB(DataList4, strQuery); foreach (Faculty facult in DataList4) { FacultyDG.Items.Add(facult); } List <Stud_Group> DataList5 = new List <Stud_Group>(); strQuery = "select * from Stud_Group"; DBUtils.GetFromDB(DataList5, strQuery); foreach (Stud_Group s_g in DataList5) { Stud_GroupDG.Items.Add(s_g); } List <Group_Disc> DataList6 = new List <Group_Disc>(); strQuery = "select * from Group_Disc"; DBUtils.GetFromDB(DataList6, strQuery); foreach (Group_Disc g_d in DataList6) { Group_DiscDG.Items.Add(g_d); } }