public void BindInspectionSummary(string Year)
{
try
{
ds = objInsp.GetYearlyInspectionSummary(Year);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
while (true)
{
int colcount = ds.Tables[0].Columns.Count;
bool found = false;
for (int i = 0; i <= colcount - 1; i++)
{
if (ds.Tables[0].Columns[i].ColumnName.Contains(Convert.ToString(Convert.ToInt32(Year) - 4)))
{
found = true;
ds.Tables[0].Columns.RemoveAt(i);
ds.Tables[1].Columns.RemoveAt(i);
//colcount -= 1;
break;
}
}
if (found == false)
{
break;
}
}
grdSummary.DataSource = ds.Tables[0];
grdSummary.DataBind();
GetStatistics();
}
else
{
}
}
else
{
grdSummary.DataSource = null;
grdSummary.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
}