public override global::System.Data.DataTable Clone()
{
StudentsDataTable cln = ((StudentsDataTable)(base.Clone()));
cln.InitVars();
return(cln);
}
public StudentsDataTable GetStudentsTable()
{
StudentsDataTable table = new StudentsDataTable();
disconnectedDBAccess.Fill(table);
return(table);
}
private void InitClass()
{
this.DataSetName = "StudentsDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/StudentsDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableStudents = new StudentsDataTable();
base.Tables.Add(this.tableStudents);
}
internal void InitVars(bool initTable)
{
this.tableStudents = ((StudentsDataTable)(base.Tables["Students"]));
if ((initTable == true))
{
if ((this.tableStudents != null))
{
this.tableStudents.InitVars();
}
}
}
public static void DisconnectedArchitecture_9()
{
DisconnectedDataAccess <StudentsDataTable> dbAccess = new DisconnectedDataAccess <StudentsDataTable>();
initSelectCommand(dbAccess);
initUpdateCommand(dbAccess);
initInsertCommand(dbAccess);
initDeleteCommand(dbAccess);
StudentsDataTable table = new StudentsDataTable();
dbAccess.Fill(table);
Console.WriteLine("All datatable data:");
printRows(table.Rows);
// Change row in DataTable
StudentsRow row = (StudentsRow)table.Rows[0];
row.first_name = "Mickey";
Console.WriteLine("All datatable data - after datarow change:");
printRows(table.Rows);
// Compare to data in db
Console.WriteLine("All db data - before update:");
ConnectedExamples.BasicReaderQuery_1();
dbAccess.Update(table);
// Compare to data in db after update
Console.WriteLine("All db data - after update:");
ConnectedExamples.BasicReaderQuery_1();
// Do not forget to dispose!
dbAccess.Dispose();
}
// 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 StudentsRow(global::System.Data.DataRowBuilder rb) :
base(rb)
{
this.tableStudents = ((StudentsDataTable)(this.Table));
}
public int UpdateStudentsTable(StudentsDataTable table)
{
return(disconnectedDBAccess.Update(table));
}
