public void LoadEvent() { isProcess=false; //int year=0, month=0; DateTime dtStart = SqlDateTime.MinValue.Value; DateTime dtEnd = SqlDateTime.MaxValue.Value; if(IsLoad) { PopulateDropDowns(); LoadFilterSettings(); } if (datePickerStart.Checked) dtStart = datePickerStart.Value; if (datePickerEnd.Checked) dtEnd = datePickerEnd.Value; IsLoad=false; objEvent = new Events(); //dtbl = objEvent.LoadData(dtStart, dtEnd, cmbClient.Text, cmbInstructor.Text, cmbProgram.Text, cmbClass.Text); //dtbl = objEvent.LoadData(dtStart, dtEnd, ((ValuePair)cmbClient.SelectedItem).Value, ((ValuePair)cmbInstructor.SelectedItem).Value, "", "",true); if (!isNewLoad) { dtbl = objEvent.LoadDataNew(dtStart, dtEnd, ((ValuePair)cmbClient.SelectedItem).Value, ((ValuePair)cmbInstructor.SelectedItem).Value, ((ValuePair)cmbProgram.SelectedItem).Value, ((ValuePair)cmbClass.SelectedItem).Value, true); //dtbl = objEvent.LoadDataNew(dtStart, dtEnd, "", "", "", "", true); grdEvent.DataSource = dtbl; } isProcess = true; isNewLoad = false; }