Example #1
0
        public DataBaseHandler()
        {
            //SqlConnection conn = new SqlConnection(connectionString);
            //conn.Open();
            DataSet = (CourseSchedulerDBDataSet)Application.Current.FindResource("courseSchedulerDBDataSet");

            NoRelation_RoomsTableAdapter                          = new CourseSchedulerDBDataSetTableAdapters.NoRelation_RoomsTableAdapter();
            NoRelation_CoursesTableAdapter                        = new CourseSchedulerDBDataSetTableAdapters.NoRelation_CoursesTableAdapter();
            NoRelation_StudentsTableAdapter                       = new CourseSchedulerDBDataSetTableAdapters.NoRelation_StudentsTableAdapter();
            NoRelation_SchedulesTableAdapter                      = new CourseSchedulerDBDataSetTableAdapters.NoRelation_SchedulesTableAdapter();
            NoRelation_InstructorsTableAdapter                    = new CourseSchedulerDBDataSetTableAdapters.NoRelation_InstructorsTableAdapter();
            NoRelation_CombinationsTableAdapter                   = new CourseSchedulerDBDataSetTableAdapters.NoRelation_CombinationsTableAdapter();
            NoRelation_PossibleCoursesTableAdapter                = new CourseSchedulerDBDataSetTableAdapters.NoRelation_PossibleCoursesTableAdapter();
            NoRelation_CourseEnrollmentsTableAdapter              = new CourseSchedulerDBDataSetTableAdapters.NoRelation_CourseEnrollmentsTableAdapter();
            NoRelation_CourseCombinationsTableAdapter             = new CourseSchedulerDBDataSetTableAdapters.NoRelation_CourseCombinationsTableAdapter();
            NoRelation_InstructorPreferencesTableAdapter          = new CourseSchedulerDBDataSetTableAdapters.NoRelation_InstructorPreferencesTableAdapter();
            NoRelation_Join_Schedules_PossibleCoursesTableAdapter = new CourseSchedulerDBDataSetTableAdapters.NoRelation_Join_Schedules_PossibleCoursesTableAdapter();
            Join_Schedules_PossibleCoursesTableAdapter            = new CourseSchedulerDBDataSetTableAdapters.Join_Schedules_PossibleCoursesTableAdapter();
            InstructorPreferencesTableAdapter                     = new CourseSchedulerDBDataSetTableAdapters.InstructorPreferencesTableAdapter();
            CourseCombinationsTableAdapter                        = new CourseSchedulerDBDataSetTableAdapters.CourseCombinationsTableAdapter();
            CourseEnrollmentsTableAdapter                         = new CourseSchedulerDBDataSetTableAdapters.CourseEnrollmentsTableAdapter();
            PossibleCoursesTableAdapter = new CourseSchedulerDBDataSetTableAdapters.PossibleCoursesTableAdapter();
            CombinationsTableAdapter    = new CourseSchedulerDBDataSetTableAdapters.CombinationsTableAdapter();
            InstructorsTableAdapter     = new CourseSchedulerDBDataSetTableAdapters.InstructorsTableAdapter();
            SchedulesTableAdapter       = new CourseSchedulerDBDataSetTableAdapters.SchedulesTableAdapter();
            StudentsTableAdapter        = new CourseSchedulerDBDataSetTableAdapters.StudentsTableAdapter();
            CoursesTableAdapter         = new CourseSchedulerDBDataSetTableAdapters.CoursesTableAdapter();
            RoomsTableAdapter           = new CourseSchedulerDBDataSetTableAdapters.RoomsTableAdapter();

            TableAdapterManager = new CourseSchedulerDBDataSetTableAdapters.TableAdapterManager();

            TableAdapterManager.RoomsTableAdapter                                     = RoomsTableAdapter;
            TableAdapterManager.CoursesTableAdapter                                   = CoursesTableAdapter;
            TableAdapterManager.StudentsTableAdapter                                  = StudentsTableAdapter;
            TableAdapterManager.SchedulesTableAdapter                                 = SchedulesTableAdapter;
            TableAdapterManager.InstructorsTableAdapter                               = InstructorsTableAdapter;
            TableAdapterManager.PossibleCoursesTableAdapter                           = PossibleCoursesTableAdapter;
            TableAdapterManager.CourseEnrollmentsTableAdapter                         = CourseEnrollmentsTableAdapter;
            TableAdapterManager.CourseCombinationsTableAdapter                        = CourseCombinationsTableAdapter;
            TableAdapterManager.InstructorPreferencesTableAdapter                     = InstructorPreferencesTableAdapter;
            TableAdapterManager.Join_Schedules_PossibleCoursesTableAdapter            = Join_Schedules_PossibleCoursesTableAdapter;
            TableAdapterManager.NoRelation_Join_Schedules_PossibleCoursesTableAdapter = NoRelation_Join_Schedules_PossibleCoursesTableAdapter;
            TableAdapterManager.NoRelation_InstructorPreferencesTableAdapter          = NoRelation_InstructorPreferencesTableAdapter;
            TableAdapterManager.NoRelation_CourseCombinationsTableAdapter             = NoRelation_CourseCombinationsTableAdapter;
            TableAdapterManager.NoRelation_CourseEnrollmentsTableAdapter              = NoRelation_CourseEnrollmentsTableAdapter;
            TableAdapterManager.NoRelation_PossibleCoursesTableAdapter                = NoRelation_PossibleCoursesTableAdapter;
            TableAdapterManager.NoRelation_InstructorsTableAdapter                    = NoRelation_InstructorsTableAdapter;
            TableAdapterManager.NoRelation_SchedulesTableAdapter                      = NoRelation_SchedulesTableAdapter;
            TableAdapterManager.NoRelation_StudentsTableAdapter                       = NoRelation_StudentsTableAdapter;
            TableAdapterManager.NoRelation_CoursesTableAdapter                        = NoRelation_CoursesTableAdapter;
            TableAdapterManager.NoRelation_RoomsTableAdapter                          = NoRelation_RoomsTableAdapter;

            FillAdaptersWithDataSet();
        }