public static Department.DepartmentSelectCommandRow GetDepartment(int deptId)
 {
     Department.DepartmentSelectCommandRow dataRow = null;
     DepartmentTableAdapters.DepartmentSelectCommandTableAdapter da = new DepartmentTableAdapters.DepartmentSelectCommandTableAdapter();
     IEnumerator iEnumerator = da.GetDepartmentByDeptId(deptId).GetEnumerator();
     if (iEnumerator.MoveNext())
     {
         dataRow = (Department.DepartmentSelectCommandRow)iEnumerator.Current;
     }
     return dataRow;
 }
 private DataTable getDepartment(int departmentId)
 {
     DepartmentTableAdapters.DepartmentSelectCommandTableAdapter tableAdapter = new DepartmentTableAdapters.DepartmentSelectCommandTableAdapter();
     DataTable dt = tableAdapter.GetDepartmentByDeptId(departmentId);
     return dt;
 }