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