public void UpdateDesignProjectsDB(DesignProjectsDataSet aDesignProjectsDataSet)
 {
     try
     {
         aDesignProjectsTableAdapter = new DesignProjectsDataSetTableAdapters.designprojectsTableAdapter();
         aDesignProjectsTableAdapter.Update(aDesignProjectsDataSet.designprojects);
     }
     catch (Exception Ex)
     {
         TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Design Project Class // Update Design Projects DB " + Ex.Message);
     }
 }
        public DesignProjectsDataSet GetDesignProjectsInfo()
        {
            try
            {
                aDesignProjectsDataSet      = new DesignProjectsDataSet();
                aDesignProjectsTableAdapter = new DesignProjectsDataSetTableAdapters.designprojectsTableAdapter();
                aDesignProjectsTableAdapter.Fill(aDesignProjectsDataSet.designprojects);
            }
            catch (Exception Ex)
            {
                TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Design Project Class // Get Design Projects Info " + Ex.Message);
            }

            return(aDesignProjectsDataSet);
        }