// method to read data from dataset public void Read() { // create table adapters for each table in the dataset ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter taEmployees = new ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter(); ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter taProjects = new ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter(); ProjectTrackingDataSetTableAdapters.StatusTableAdapter taStatus = new ProjectTrackingDataSetTableAdapters.StatusTableAdapter(); ProjectTrackingDataSetTableAdapters.TasksTableAdapter taTasks = new ProjectTrackingDataSetTableAdapters.TasksTableAdapter(); ProjectTrackingDataSetTableAdapters.WorkTableAdapter taWork = new ProjectTrackingDataSetTableAdapters.WorkTableAdapter(); try { // load the data into the tables taEmployees.Fill(myProjects.Employees); taProjects.Fill(myProjects.Projects); taStatus.Fill(myProjects.Status); taTasks.Fill(myProjects.Tasks); taWork.Fill(myProjects.Work); } catch (Exception ex) { SetReadyLabel("Error loading data from database"); MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
// method to save data to dataset public void Save() { // create table adapters for each table in the dataset ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter taEmployees = new ProjectTrackingDataSetTableAdapters.EmployeesTableAdapter(); ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter taProjects = new ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter(); ProjectTrackingDataSetTableAdapters.StatusTableAdapter taStatus = new ProjectTrackingDataSetTableAdapters.StatusTableAdapter(); ProjectTrackingDataSetTableAdapters.TasksTableAdapter taTasks = new ProjectTrackingDataSetTableAdapters.TasksTableAdapter(); ProjectTrackingDataSetTableAdapters.WorkTableAdapter taWork = new ProjectTrackingDataSetTableAdapters.WorkTableAdapter(); // create instance of table adapter manager to manage all tables ProjectTrackingDataSetTableAdapters.TableAdapterManager taManager = new ProjectTrackingDataSetTableAdapters.TableAdapterManager(); // assign each table table adapter to the table adapter manager taManager.EmployeesTableAdapter = taEmployees; taManager.ProjectsTableAdapter = taProjects; taManager.StatusTableAdapter = taStatus; taManager.TasksTableAdapter = taTasks; taManager.WorkTableAdapter = taWork; try { // using manager, update all of the tables taManager.UpdateAll(myProjects); } catch (Exception ex) { SetReadyLabel("Error saving to database"); MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }