attend.getData(); //function call to get record in dataset var l = (from x in _attend.AttendanceDS.Tables["EmpAttendanceSummary"].AsEnumerable() select new AttendanceSummary { EmpId = x.Field("EMPLOYEE_ID"), TotalHours = String.IsNullOrEmpty(x.Field ("TotalWorkingHours")) ? 0 :Convert.ToInt64(x.Field ("TotalWorkingHours")), Department = x.Field ("department_id"), Designation = x.Field ("designation_id"), }).ToList(); //now you can get values from list by class object AttendanceSummary _o = new AttendanceSummary(); _o. HighestHours = l.Max(p => p.TotalHours); _o. DepartmentHighestHours = l.Where(p => p.TotalHours > 0 && p.Department == int.Parse(5001)).Max(p => p.TotalHours); return _o; public class AttendanceSummary { public Int64 EmpId { get; set; } public Int64 TotalHours { get; set; } public int Department { get; set; } public int Designation { get; set; } public long HighestHours { get; set; } public long DepartmentHighestHours { get; set; } }
Saturday, 27 August 2011
Converting Datatable into List
Labels:
dotnet
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment