// 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);
}