private void LoadSummary()
{
Database data = new Database();
DataView dv = data.GetTop25Summary(Convert.ToDateTime(lstStartMonth.SelectedValue),
Convert.ToDateTime(lstEndMonth.SelectedValue),
Convert.ToBoolean(lstApproved.SelectedValue),
lstRegion.SelectedValue,
lstArea.SelectedValue,
lstLSO.SelectedValue,
SalesManagerID);
if (ViewState[SUMMARY_SORT_KEY] != null)
{
dv.Sort = Convert.ToString(ViewState[SUMMARY_SORT_KEY]);
}
grdSummary.DataSource = dv;
grdSummary.DataBind();
data.Close();
data.Dispose();
}