public override global::System.Data.DataTable Clone()
{
CoursesDataTable cln = ((CoursesDataTable)(base.Clone()));
cln.InitVars();
return(cln);
}
private void InitClass()
{
this.DataSetName = "School_SystemDataSet6";
this.Prefix = "";
this.Namespace = "http://tempuri.org/School_SystemDataSet6.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableCourses = new CoursesDataTable();
base.Tables.Add(this.tableCourses);
}
internal void InitVars(bool initTable)
{
this.tableCourses = ((CoursesDataTable)(base.Tables["Courses"]));
if ((initTable == true))
{
if ((this.tableCourses != null))
{
this.tableCourses.InitVars();
}
}
}
// create the data tables from lists set up with initial data
// we won't use these lists or the classes after the data tables are created
private void CreateRegistrationDataTables()
{
// set the shorter table names
registrationTable = studentRegistrationDataSet.Registration;
coursesTable = studentRegistrationDataSet.Courses;
studentsTable = studentRegistrationDataSet.Students;
departmentsTable = studentRegistrationDataSet.Departments;
// seed all the table data
// students data
List <Student> students = new List <Student>()
{
new Student {
StudentFirstName = "Svetlana", StudentLastName = "Rostov", StudentMajor = "CSIS"
},
new Student {
StudentFirstName = "Claire", StudentLastName = "Bloome", StudentMajor = "ACCT"
},
new Student {
StudentFirstName = "Sven", StudentLastName = "Baertschi", StudentMajor = "MKTG"
},
new Student {
StudentFirstName = "Cesar", StudentLastName = "Chavez", StudentMajor = "FINC"
},
new Student {
StudentFirstName = "Debra", StudentLastName = "Manning", StudentMajor = "CSIS"
},
new Student {
StudentFirstName = "Fadi", StudentLastName = "Hadari", StudentMajor = "ACCT"
},
new Student {
StudentFirstName = "Hanyeng", StudentLastName = "Fen", StudentMajor = "MKTG"
},
new Student {
StudentFirstName = "Hugo", StudentLastName = "Victor", StudentMajor = "FINC"
},
new Student {
StudentFirstName = "Lance", StudentLastName = "Armstrong", StudentMajor = "MKTG"
},
new Student {
StudentFirstName = "Terry", StudentLastName = "Matthews", StudentMajor = "CSIS"
},
new Student {
StudentFirstName = "Eugene", StudentLastName = "Fei", StudentMajor = "FINC"
},
new Student {
StudentFirstName = "Michael", StudentLastName = "Thorson", StudentMajor = "CSIS"
},
new Student {
StudentFirstName = "Simon", StudentLastName = "Li", StudentMajor = "CSIS"
},
};
// departments data
List <Department> departments = new List <Department>()
{
new Department {
DepartmentId = "CSIS", DepartmentName = "Computing Studies"
},
new Department {
DepartmentId = "ACCT", DepartmentName = "Accounting"
},
new Department {
DepartmentId = "MKTG", DepartmentName = "Marketing"
},
new Department {
DepartmentId = "FINC", DepartmentName = "Finance"
},
};
// courses data
List <Course> courses = new List <Course>()
{
new Course {
CourseId = 101, CourseDepartmentId = "CSIS", CourseName = "Programming I"
},
new Course {
CourseId = 102, CourseDepartmentId = "CSIS", CourseName = "Programming II"
},
new Course {
CourseId = 101, CourseDepartmentId = "ACCT", CourseName = "Accounting I"
},
new Course {
CourseId = 102, CourseDepartmentId = "ACCT", CourseName = "Accounting II"
},
new Course {
CourseId = 101, CourseDepartmentId = "FINC", CourseName = "Corporate Finance"
},
};
// registration data - note consists of a registration object, and a student id.
// if the students table is set up with a different autoincrement that starting at 1, this won't work
List <Registration> registrations = new List <Registration>()
{
new Registration {
RegisteredCourse = courses[0], StudentId = 1
},
new Registration {
RegisteredCourse = courses[0], StudentId = 2
},
new Registration {
RegisteredCourse = courses[1], StudentId = 1
},
new Registration {
RegisteredCourse = courses[4], StudentId = 1
},
};
// for each table, Fill the dataset table with data from the database (should be zero).
// this also instantiates sql commands
registrationTableAdapter.Fill(registrationTable);
coursesTableAdapter.Fill(coursesTable);
studentsTableAdapter.Fill(studentsTable);
departmentsTableAdapter.Fill(departmentsTable);
// make sure student id starts at 1
ReseedTable(studentsTableAdapter.Connection, studentsTable.TableName, studentsTable.Count());
// remove any data that is in the data tables.
// assumes that the tables have been set up properly using the sql project in this solution
DeleteData(registrationTableAdapter.Adapter, registrationTable);
DeleteData(coursesTableAdapter.Adapter, coursesTable);
DeleteData(studentsTableAdapter.Adapter, studentsTable);
DeleteData(departmentsTableAdapter.Adapter, departmentsTable);
// for each object in the lists above that corresponds to the data table, insert a record
// then Update, and re Fill the data table
// add Students using adapter insert, then update and fill
// then bind the datasource to the table
// this is already done for you
foreach (Student s in students)
{
// an alternative to using the Insert method
//StudentRegistrationDataSet.StudentsRow row = studentRegistrationDataSet.Students.NewStudentsRow();
//row.StudentFirstName = s.StudentFirstName;
//row.StudentLastName = s.StudentLastName;
//row.StudentMajor = s.StudentMajor;
//studentRegistrationDataSet.Students.AddStudentsRow(row);
studentsTableAdapter.Insert(s.StudentFirstName, s.StudentLastName, s.StudentMajor);
}
studentsTableAdapter.Update(studentsTable);
studentsTableAdapter.Fill(studentsTable);
dataGridViewStudents.DataSource = studentsTable;
// add Departments, then update and fill, and bind datasource
// your code here
foreach (Department d in departments)
{
departmentsTableAdapter.Insert(d.DepartmentId, d.DepartmentName);
}
departmentsTableAdapter.Update(departmentsTable);
departmentsTableAdapter.Fill(departmentsTable);
dataGridViewDepartments.DataSource = departmentsTable;
// add Courses, then update and fill, and bind datasource
// your code here
foreach (Course c in courses)
{
coursesTableAdapter.Insert(c.CourseId, c.CourseDepartmentId, c.CourseName);
}
coursesTableAdapter.Update(coursesTable);
coursesTableAdapter.Fill(coursesTable);
dataGridViewCourses.DataSource = coursesTable;
// sort the courses in gridview
// hint: use the Sort() method on column 0, ascending
// your code here
dataGridViewCourses.Sort(dataGridViewCourses.Columns[0], ListSortDirection.Ascending);
// add Registration last. add the registrations then update and fill again
// finally, set DataSource to the table
foreach (Registration r in registrations)
{
registrationTableAdapter.Insert(r.StudentId, r.RegisteredCourse.CourseId, r.RegisteredCourse.CourseDepartmentId);
}
registrationTableAdapter.Update(registrationTable);
registrationTableAdapter.Fill(registrationTable);
dataGridViewRegistration.DataSource = registrationTable;
//registrationTableAdapter.Fill(registrationTable); // instantiates sql commands
// your code here
}
internal CoursesRow(global::System.Data.DataRowBuilder rb) :
base(rb)
{
this.tableCourses = ((CoursesDataTable)(this.Table));
}
private void InitClass() {
this.DataSetName = "Database";
this.Prefix = "";
this.Namespace = "http://tempuri.org/Database.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableCourses = new CoursesDataTable();
base.Tables.Add(this.tableCourses);
this.tablePreferences = new PreferencesDataTable();
base.Tables.Add(this.tablePreferences);
this.tableProfs = new ProfsDataTable();
base.Tables.Add(this.tableProfs);
this.tableSolution = new SolutionDataTable();
base.Tables.Add(this.tableSolution);
this.relationFK_Preferences_Courses = new global::System.Data.DataRelation("FK_Preferences_Courses", new global::System.Data.DataColumn[] {
this.tableCourses.CourseIDColumn}, new global::System.Data.DataColumn[] {
this.tablePreferences.CourseIDColumn}, false);
this.Relations.Add(this.relationFK_Preferences_Courses);
this.relationFK_Courses_Profs = new global::System.Data.DataRelation("FK_Courses_Profs", new global::System.Data.DataColumn[] {
this.tableProfs.ProfIDColumn}, new global::System.Data.DataColumn[] {
this.tableCourses.ProfIDColumn}, false);
this.Relations.Add(this.relationFK_Courses_Profs);
this.relationFK_Preferences_Profs = new global::System.Data.DataRelation("FK_Preferences_Profs", new global::System.Data.DataColumn[] {
this.tableProfs.ProfIDColumn}, new global::System.Data.DataColumn[] {
this.tablePreferences.ProfIDColumn}, false);
this.Relations.Add(this.relationFK_Preferences_Profs);
}
internal void InitVars(bool initTable) {
this.tableCourses = ((CoursesDataTable)(base.Tables["Courses"]));
if ((initTable == true)) {
if ((this.tableCourses != null)) {
this.tableCourses.InitVars();
}
}
this.tablePreferences = ((PreferencesDataTable)(base.Tables["Preferences"]));
if ((initTable == true)) {
if ((this.tablePreferences != null)) {
this.tablePreferences.InitVars();
}
}
this.tableProfs = ((ProfsDataTable)(base.Tables["Profs"]));
if ((initTable == true)) {
if ((this.tableProfs != null)) {
this.tableProfs.InitVars();
}
}
this.tableSolution = ((SolutionDataTable)(base.Tables["Solution"]));
if ((initTable == true)) {
if ((this.tableSolution != null)) {
this.tableSolution.InitVars();
}
}
this.relationFK_Preferences_Courses = this.Relations["FK_Preferences_Courses"];
this.relationFK_Courses_Profs = this.Relations["FK_Courses_Profs"];
this.relationFK_Preferences_Profs = this.Relations["FK_Preferences_Profs"];
}
internal CoursesRow(global::System.Data.DataRowBuilder rb) :
base(rb) {
this.tableCourses = ((CoursesDataTable)(this.Table));
}
