private void FillGrid() { try { DataTable DtList = null; ML_SanitizationReport objML_SanitizationReportSearch = new ML_SanitizationReport(); if (ddlReportTypeSearch.SelectedIndex > 0 && !string.IsNullOrEmpty(txtFromDateSearch.Text) && !string.IsNullOrEmpty(txtToDateSearch.Text)) { objML_SanitizationReportSearch.ReportType = ML_Common.GetDropDownValue(ddlReportTypeSearch, true); objML_SanitizationReportSearch.TagStatus = null; DateTime FromDateSearch = ML_Common.ToDateTimeSafe(txtFromDateSearch.Text); DateTime ToDateSearch = ML_Common.ToDateTimeSafe(txtToDateSearch.Text); var FromTimeSearch = TimeSpan.Parse("00:00:00"); var FromFullDt = FromDateSearch + FromTimeSearch; // 2010-06-26 01:16:50 var ToTimeSearch = TimeSpan.Parse("23:59:59"); var ToFullDt = ToDateSearch + ToTimeSearch; // 2010-06-26 01:16:50 var From24Hour = FromFullDt.ToString("MM/dd/yyyy HH:mm:ss", CultureInfo.CurrentCulture); var To24Hour = ToFullDt.ToString("MM/dd/yyyy HH:mm:ss", CultureInfo.CurrentCulture); objML_SanitizationReportSearch.FromDate = ML_Common.ToDateTimeSafeNull(From24Hour.ToString()); objML_SanitizationReportSearch.ToDate = ML_Common.ToDateTimeSafeNull(To24Hour.ToString()); DtList = BindGridViewBySearch(objML_SanitizationReportSearch); } if (DtList != null) { //DtList = (DataTable)ViewState["grdSanitizationReportTM"]; if (DtList.Rows.Count > 0) { grdSanitizationReport.DataSource = DtList; grdSanitizationReport.DataBind(); } else { DtList.Rows.Add(DtList.NewRow()); grdSanitizationReport.DataSource = DtList; grdSanitizationReport.DataBind(); int TotalColumns = grdSanitizationReport.Rows[0].Cells.Count; grdSanitizationReport.Rows[0].Cells.Clear(); grdSanitizationReport.Rows[0].Cells.Add(new TableCell()); grdSanitizationReport.Rows[0].Cells[0].ColumnSpan = TotalColumns; grdSanitizationReport.Rows[0].Cells[0].Text = "No Record Found"; } UpdatePanelGrid.Update(); } } catch (Exception ex) { Exception exc = ex; } }