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