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;
}
}
