public DataView GetGymAttendance(DateTime dtDate) { TblClassAttendance classAttendance = new TblClassAttendance(); DataTable table = classAttendance.GetGymAttendancesBaseDate(dtDate, ACMSLogic.User.BranchCode); table.DefaultView.RowFilter = "nTypeID = 1 And (nStatusID = 1 or nStatusID = 2 or nStatusID = 4 or nStatusID is null)"; return table.DefaultView; }