public void BindSearchGrid() { objBll = new WarringtonBll.WarringtonBll(); SearchParam objSearchParam = new SearchParam() { UserId = Utility.GetSessionValue<string>(Constants._LOGINUSERID), RequestStatus = txtStatus.Text, RequestNo = txtRequestNo.Text, RequestDate = string.IsNullOrEmpty(txtRequestDate.Text) ? DateTime.MinValue : DateTime.ParseExact(txtRequestDate.Text, "MM/dd/yyyy", null), CompareOperator=ddlOperator.SelectedValue, NoOfData=Convert.ToInt32(ddlPageSize.SelectedValue) }; List<UserRequest> lstRequest = objBll.SearchRequest(objSearchParam); DataTable dtSearchResult = new DataTable(); dtSearchResult.Columns.Add("Request_No"); dtSearchResult.Columns.Add("Request_ID"); dtSearchResult.Columns.Add("Request_Date"); dtSearchResult.Columns.Add("Request_ChangeDate"); dtSearchResult.Columns.Add("Request_Status"); dtSearchResult.Columns.Add("Request_Address"); dtSearchResult.Columns.Add("Request_ShortDesc"); dtSearchResult.Columns.Add("Request_LongDesc"); foreach (UserRequest objrequest in lstRequest) { DataRow drRequest = dtSearchResult.NewRow(); drRequest["Request_No"] = objrequest.RequestNo; drRequest["Request_ID"] = objrequest.RequestId; drRequest["Request_Date"] = objrequest.CreateDate.Value.Date.ToShortDateString(); drRequest["Request_ChangeDate"] = objrequest.UpdateDate!=null?objrequest.UpdateDate.Value.Date.ToShortDateString():null; drRequest["Request_Status"] = objrequest.Status.Trim().Equals("O")?"Open":"Closed"; drRequest["Request_Address"] = objrequest.ProblemLocation; drRequest["Request_ShortDesc"] = objrequest.ShortDescription; drRequest["Request_LongDesc"] = objrequest.LongDescription; dtSearchResult.Rows.Add(drRequest); } dtSearchResult.AcceptChanges(); grdRequests.PageSize = Convert.ToInt32(ddlPageSize.SelectedValue); if (!dtSearchResult.DataTableIsEmpty()) { Utility.SetSessionValue(Constants._SEARCHREQUESTDATA, dtSearchResult); grdRequests.DataSource = dtSearchResult; grdRequests.DataBind(); } else { grdRequests.Dispose(); grdRequests.DataBind(); } }