protected void updateGV() { /**************send pending list*******************/ RequisitionDAO rdao = new RequisitionDAO(); string name = Session["loginID"].ToString(); lr = new List <Requisition>();//to store the pending if ((fromDate.Text == "") && (toDate.Text == "")) { lr_h = rdao.getRequisitionByStaffID(name); for (int i = lr_h.Count - 1; i >= 0; i--) { if (lr_h[i].status == "pending") { lr.Add(lr_h[i]); lr_h.RemoveAt(i); } } } else { if ((fromDate.Text == "") || (toDate.Text == "")) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage1", "alert('Plz Enter correct date range')", true); return; } DateTime from = Convert.ToDateTime(fromDate.Text); DateTime to = Convert.ToDateTime(toDate.Text); if (DateTime.Compare(from, to) > 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage2", "alert('Start Date should be greater than end Date')", true); return; } if ((fromDate.Text != "") && (toDate.Text != "")) { lr_h = rdao.findRequisitionByDateIndividual(from, to, name); for (int i = lr_h.Count - 1; i >= 0; i--) { if (lr_h[i].status == "pending") { lr.Add(lr_h[i]); lr_h.RemoveAt(i); } } } } requisitionListGridView.DataSource = lr; requisitionListGridView.DataBind(); ShowRequisition(lr_h); }