public void InsertTasksTable(int project, string name, string desc, DateTime startDate, DateTime?endDate, int status)
{
ProjectTrackingDataSetTableAdapters.TasksTableAdapter myAdapter = GetTasksAdapter();
myAdapter.Insert(project, name, desc, startDate, endDate, status);
myDataSet.Tasks.AcceptChanges();
myAdapter.Update(myDataSet.Tasks);
}
public void DeleteTasksRow(int task)
{
ProjectTrackingDataSetTableAdapters.TasksTableAdapter myAdapter = GetTasksAdapter();
myAdapter.Delete(task);
myDataSet.AcceptChanges();
myAdapter.Update(myDataSet.Tasks);
}
public void UpdateTasksRow(int rowIndex, int project, string name, string desc, DateTime startDate, DateTime?endDate, int status)
{
ProjectTrackingDataSetTableAdapters.TasksTableAdapter myAdapter = GetTasksAdapter();
myDataSet.Tasks[rowIndex][1] = project;
myDataSet.Tasks[rowIndex][2] = name;
myDataSet.Tasks[rowIndex][3] = desc;
myDataSet.Tasks[rowIndex][4] = startDate;
if (endDate == null)
{
myDataSet.Tasks[rowIndex][5] = DBNull.Value;
}
else
{
myDataSet.Tasks[rowIndex][5] = endDate;
}
myDataSet.Tasks[rowIndex][6] = status;
myAdapter.Update(myDataSet.Tasks);
}
