//query pagination data
 private void QueryPaginationData()
 {
     paginationUtils.TotalRecord = examManager.GetTeacherExamListCount(fromDate, toDate, examName);
     TeacherExamManager.SearchExamListDataTable table = examManager.GetTeacherExamList(TeacherQueryExamListState.SortColumn, TeacherQueryExamListState.SortDirection,
                                                                                       paginationUtils.CurrentPage, paginationUtils.PageSize, fromDate, toDate, examName);
     this.dgvExamList.DataSource = table;
     EditDataGridView();
 }
        private void DynamicSort(string SortColumn, string SortDirection)
        {
            TeacherQueryExamListState.SortColumn    = SortColumn;
            TeacherQueryExamListState.SortDirection = SortDirection;

            TeacherExamManager.SearchExamListDataTable table = examManager.GetTeacherExamList(TeacherQueryExamListState.SortColumn, TeacherQueryExamListState.SortDirection,
                                                                                              paginationUtils.CurrentPage, paginationUtils.PageSize, this.fromDate, this.toDate, this.examName);
            this.dgvExamList.DataSource = table;
            EditDataGridView();
        }