how will do custom sorting using div express controls in asp.net MVC

getDataRowCountMethod of the GridViewCustomBindingGetDataRowCountHandler type Provide implementation for this method to return the total number of data rows. getDataMethod of the GridViewCustomBindingGetDataHandler type Provide implementation for this method to return the required data rows to the grid. getSummaryValuesMethod of the GridViewCustomBindingGetSummaryValuesHandler type Provide implementation for this method to calculate and return values of summaries required within the grid. getGroupingInfoMethod of the GridViewCustomBindingGetGroupingInfoHandler type Provide implementation for this method to return data rows for visible and expanded groups in the required order that depends on the applied grouping and sorting. getUniqueHeaderFilterValuesMethod of the GridViewCustomBindingGetUniqueHeaderFilterValuesHandler type Provide implementation for this method to return unique values to be displayed in the header filter popup list invoked for a column. - See more at: http://www.urbanpro.com/asp-net/how-will-do-custom-sorting-using-div-express-controls/2804212#sthash.Os75dZ6h.dpuf read less

using System; using DevExpress.XtraPivotGrid; using System.Collections; using DevExpress.Data.Linq; using DevExpress.Web.ASPxPivotGrid; namespace ASPxPivotGridCustomServerModeSort { public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack && !IsCallback) { PivotGridField field = ASPxPivotGrid1.Fields["Year"]; ASPxPivotGrid1.BeginUpdate(); try { field.FilterValues.Clear(); field.FilterValues.Add(1996); field.FilterValues.FilterType = DevExpress.XtraPivotGrid.PivotFilterType.Included; } finally { ASPxPivotGrid1.EndUpdate(); } } // Sets fields' sort mode to Custom to raise the CustomServerModeSort event. fieldOrderMonth.SortMode = PivotSortMode.Custom; fieldCategoryName.SortMode = PivotSortMode.Custom; } protected void EntityServerModeDataSource1_Selecting(object sender, LinqServerModeDataSourceSelectEventArgs e) { e.KeyExpression = "OrderID"; e.QueryableSource = new ASPxPivotGridCustomServerModeSort.NWindEntities().SalesPersons; } protected void ASPxPivotGrid1_CustomServerModeSort(object sender, CustomServerModeSortEventArgs e) { // Sorting using a cross area object. if (e.Field.ID == "fieldOrderMonth") { // Sets the cross area key, by which the "Month" field will be sorted. // In this example, it's one of the "Category" cross area field values. CrossAreaKey sorting = e.GetCrossAreaKey(new object[] { "Dairy Products" }); // Sets the result of the "Month" field's values comparison // by the cross area key object and the "Price" field. e.Result = Comparer.Default.Compare( e.GetCellValue1(sorting, fieldPrice), e.GetCellValue2(sorting, fieldPrice) ); // Allows you to change the "Month" field's sort order without lose of sorting. if (fieldOrderMonth.SortOrder == PivotSortOrder.Descending) e.Result *= -1; } // Direct sorting without using a cross area object. if (e.Field.ID == "fieldCategoryName") { // Sets the result of "Category" field's values comparison by the Year and Price fields. e.Result = Comparer.Default.Compare( e.GetCellValue1(new object[] { "1996" }, fieldPrice), e.GetCellValue2(new object[] { "1996" }, fieldPrice) ); // Allows you to change the "Category" field's sort order without lose of sorting. if (fieldCategoryName.SortOrder == PivotSortOrder.Descending) e.Result *= -1; } } } read less

In Throw, the original exception stack trace will be retained. To keep the original stack trace information, the correct syntax is 'throw' without specifying an exception. In Throw ex, the original stack trace information will get override and you will lose the original exception stack trace. I.e. 'throw ex' resets the stack trace. read less