// 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); } }
private void FillComboBoxes() { //gather all table information ProjectTrackingDataSetTableAdapters.LuStatusTableAdapter myStatusAdapter = new ProjectTrackingDataSetTableAdapters.LuStatusTableAdapter(); myStatusAdapter.Fill(parent.MyDataSet.LuStatus); ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter myProjectAdapter = new ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter(); myProjectAdapter.Fill(parent.MyDataSet.Projects); //add the list of managers to the manager combobox using thier EmpID as the value member cbProjectID.DataSource = parent.MyDataSet.Projects.Copy();//use copy so that a change in one form doesn't affect this //add the list of status to the status combobox using the StatusID as the value member cbStatus.DataSource = parent.MyDataSet.LuStatus.Copy(); }
private void frmEditProjectInfo_Load(object sender, EventArgs e) { ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter myAdapter = new ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter(); myAdapter.Fill(parent.MyDataSet.Projects); UpdateSelectedRow(); manageEditingEnables(true); FillComboBoxes(); cbProjectManager.DisplayMember = "FullName"; cbProjectManager.ValueMember = "EmployeeID"; cbProjectStatus.ValueMember = "StatusID"; cbProjectStatus.DisplayMember = "StatusName"; }
protected override void fillControls() { try { parent.SetReadyLabel("Loading"); ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter myAdapter = new ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter(); myAdapter.Fill(parent.MyDataSet.Projects); numRows = parent.MyDataSet.Projects.Count; //put the stored values into the conrols tbProjectID.Text = parent.MyDataSet.Projects[rowIndex][0].ToString(); tbProjectName.Text = parent.MyDataSet.Projects[rowIndex][1].ToString(); cbProjectManager.SelectedValue = parent.MyDataSet.Projects[rowIndex][2]; cbProjectStatus.SelectedValue = parent.MyDataSet.Projects[rowIndex][3]; tbDescription.Text = parent.MyDataSet.Projects[rowIndex][4].ToString(); dtpStartDate.Value = DateTime.Parse(parent.MyDataSet.Projects[rowIndex][5].ToString()); DateTime endDate = new DateTime();//if the end date is valid if (DateTime.TryParse(parent.MyDataSet.Projects[rowIndex][6].ToString(), out endDate)) { mtbEndDate.Text = endDate.ToShortDateString();//include it } else { mtbEndDate.Text = ""; } } catch { parent.SetReadyLabel("Load Failed"); } }
public ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter GetProjectsAdapter() { ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter pData = new ProjectTrackingDataSetTableAdapters.ProjectsTableAdapter(); pData.Fill(myDataSet.Projects); return(pData); }