private void GetLeavesDetails(string p, DateTime startdate, DateTime Enddate, int AppovedStatusID,int shiftID) { try { EmployeeBL obj = new EmployeeBL(); DataTable dt = obj.GetLeaveDetailsByLoction(p, startdate, Enddate, AppovedStatusID,shiftID); lblMonthRep.Text = "(" + startdate.ToString("MM/dd/yyyy") + " - " + Enddate.ToString("MM/dd/yyyy") + ")"; if (dt.Rows.Count > 0) { grdUsers.DataSource = dt; grdUsers.DataBind(); Session["AllLeaveRequestData"] = dt; lblError.Visible = false; } else { lblError.Text = "No records found"; lblError.Visible = true; } BizUtility.GridSortInitail("Ascending", "Firstname", grdUsers, 0, dt); } catch (Exception ex) { } }