// 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);
}
}
protected override void fillControls()
{
try
{
parent.SetReadyLabel("Loading");
ProjectTrackingDataSetTableAdapters.TasksTableAdapter myAdapter = parent.GetTasksAdapter();
myAdapter.Fill(parent.MyDataSet.Tasks);
numRows = parent.MyDataSet.Tasks.Rows.Count;
//store the values at the row index into the controls
tbTaskID.Text = parent.MyDataSet.Tasks[rowIndex][0].ToString();
cbProjectID.SelectedValue = parent.MyDataSet.Tasks[rowIndex][1];
tbTaskName.Text = parent.MyDataSet.Tasks[rowIndex][2].ToString();
tbDescription.Text = parent.MyDataSet.Tasks[rowIndex][3].ToString();
dtpStartDate.Value = DateTime.Parse(parent.MyDataSet.Tasks[rowIndex][4].ToString());
//check if the enddate is valid
DateTime endDate = new DateTime();
if (DateTime.TryParse(parent.MyDataSet.Tasks[rowIndex][5].ToString(), out endDate))//if it is update the control
{
tbEndDate.Text = endDate.ToShortDateString();
}
else//otherwise ignore that field and make it blank
{
tbEndDate.Text = "";
}
cbStatus.SelectedValue = parent.MyDataSet.Tasks[rowIndex][6];
}
catch
{
parent.SetReadyLabel("Load Failed");
}
}
private void frmEditTaskInfo_Load(object sender, EventArgs e)
{
ProjectTrackingDataSetTableAdapters.TasksTableAdapter myAdapter = new ProjectTrackingDataSetTableAdapters.TasksTableAdapter();
myAdapter.Fill(parent.MyDataSet.Tasks);
cbProjectID.DisplayMember = "ProjectName";
cbProjectID.ValueMember = "ProjectID";
cbStatus.ValueMember = "StatusID";
cbStatus.DisplayMember = "StatusName";
FillComboBoxes();
UpdateSelectedRow();
manageEditingEnables(true);
}
public ProjectTrackingDataSetTableAdapters.TasksTableAdapter GetTasksAdapter()
{
ProjectTrackingDataSetTableAdapters.TasksTableAdapter tData = new ProjectTrackingDataSetTableAdapters.TasksTableAdapter();
tData.Fill(myDataSet.Tasks);
return(tData);
}
