New to Telerik UI for ASP.NET Core? Download free 30-day trial

Local binding

Loading Demo...

EXAMPLE
VIEW SOURCE
Edit in Theme Builder
Change Theme
Default
SASS

LESS
- Default
- Bootstrap
- Material
- Launch Theme Builder
- Black
- Blue Opal
- Bootstrap v3
- Default
- Fiori
- Flat
- High Contrast
- Material
- Material Black
- Metro
- Metro Black
- Moonlight
- Nova
- Office 365
- Silver
- Uniform

            
                        local_flat_data_binding.cshtml
                    
                        Local_Flat_Data_BindingController.cs
                    
                        ProductService.cs
                    
                        ProductViewModel.cs

Also available for:

API REFERENCE

kendo.syncReady(function(){jQuery("#configurator").kendoPivotConfigurator({"filterable":true,"sortable":true,"height":570});});kendo.syncReady(function(){jQuery("#pivotgrid").kendoPivotGrid({"filterable":true,"sortable":true,"columnWidth":120,"height":570,"configurator":"#configurator","dataSource":{"type":(function(){if(kendo.data.transports['aspnetmvc-ajax']){return 'aspnetmvc-ajax';} else{throw new Error('The kendo.aspnetmvc.min.js script is not included.');}})(),"transport":{"prefix":""},"error":onError,"rows":[{"name":"Discontinued","expand":true}],"columns":[{"name":"CategoryName","expand":true},{"name":"ProductName"}],"measures":{"values":[{"name":"Sum"}]},"schema":{"data":"Data","total":"Total","errors":"Errors","cube":{"measures":{"Average":{"field":"UnitPrice","aggregate":"average","format":"{0:c}"},"Sum":{"field":"UnitPrice","aggregate":"sum","format":"{0:c}"}},"dimensions":{"ProductName":{"caption":"All Products"},"CategoryName":{"caption":"All Categories"},"Discontinued":{"caption":"Discontinued"}}},"model":{"fields":{"ProductID":{"type":"number"},"ProductName":{"type":"string"},"UnitPrice":{"type":"number"},"UnitsInStock":{"type":"number"},"Discontinued":{"type":"boolean"},"LastSupply":{"type":"date"},"UnitsOnOrder":{"type":"number"},"Category":{"type":"object"},"CategoryID":{"type":"number","defaultValue":null},"QuantityPerUnit":{"type":"string"},"CategoryName":{"type":"string","from":"Category.CategoryName"}}}},"data":{"Data":[{"ProductID":1,"ProductName":"Chai","UnitPrice":18.0,"UnitsInStock":39,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"10 boxes x 20 bags"},{"ProductID":2,"ProductName":"Chang","UnitPrice":19.0,"UnitsInStock":17,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":40,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"24 - 12 oz bottles"},{"ProductID":3,"ProductName":"Aniseed Syrup","UnitPrice":10.0,"UnitsInStock":13,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":70,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"12 - 550 ml bottles"},{"ProductID":4,"ProductName":"Chef Anton's Cajun Seasoning","UnitPrice":22.0,"UnitsInStock":53,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"48 - 6 oz jars"},{"ProductID":5,"ProductName":"Chef Anton's Gumbo Mix","UnitPrice":21.35,"UnitsInStock":0,"Discontinued":true,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"36 boxes"},{"ProductID":6,"ProductName":"Grandma's Boysenberry Spread","UnitPrice":25.0,"UnitsInStock":120,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"12 - 8 oz jars"},{"ProductID":7,"ProductName":"Uncle Bob's Organic Dried Pears","UnitPrice":30.0,"UnitsInStock":15,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":7,"CategoryName":"Produce"},"CategoryID":7,"QuantityPerUnit":"12 - 1 lb pkgs."},{"ProductID":8,"ProductName":"Northwoods Cranberry Sauce","UnitPrice":40.0,"UnitsInStock":6,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"12 - 12 oz jars"},{"ProductID":9,"ProductName":"Mishi Kobe Niku","UnitPrice":97.0,"UnitsInStock":29,"Discontinued":true,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":6,"CategoryName":"Meat/Poultry"},"CategoryID":6,"QuantityPerUnit":"18 - 500 g pkgs."},{"ProductID":10,"ProductName":"Ikura","UnitPrice":31.0,"UnitsInStock":31,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"12 - 200 ml jars"},{"ProductID":11,"ProductName":"Queso Cabrales","UnitPrice":21.0,"UnitsInStock":22,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":30,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"1 kg pkg."},{"ProductID":12,"ProductName":"Queso Manchego La Pastora","UnitPrice":38.0,"UnitsInStock":86,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"10 - 500 g pkgs."},{"ProductID":13,"ProductName":"Konbu","UnitPrice":6.0,"UnitsInStock":24,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"2 kg box"},{"ProductID":14,"ProductName":"Tofu","UnitPrice":23.25,"UnitsInStock":35,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":7,"CategoryName":"Produce"},"CategoryID":7,"QuantityPerUnit":"40 - 100 g pkgs."},{"ProductID":15,"ProductName":"Genen Shouyu","UnitPrice":15.5,"UnitsInStock":39,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"24 - 250 ml bottles"},{"ProductID":16,"ProductName":"Pavlova","UnitPrice":17.45,"UnitsInStock":29,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"32 - 500 g boxes"},{"ProductID":17,"ProductName":"Alice Mutton","UnitPrice":39.0,"UnitsInStock":0,"Discontinued":true,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":6,"CategoryName":"Meat/Poultry"},"CategoryID":6,"QuantityPerUnit":"20 - 1 kg tins"},{"ProductID":18,"ProductName":"Carnarvon Tigers","UnitPrice":62.5,"UnitsInStock":42,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"16 kg pkg."},{"ProductID":19,"ProductName":"Teatime Chocolate Biscuits","UnitPrice":9.2,"UnitsInStock":25,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"10 boxes x 12 pieces"},{"ProductID":20,"ProductName":"Sir Rodney's Marmalade","UnitPrice":81.0,"UnitsInStock":40,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"30 gift boxes"},{"ProductID":21,"ProductName":"Sir Rodney's Scones","UnitPrice":10.0,"UnitsInStock":3,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":40,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"24 pkgs. x 4 pieces"},{"ProductID":22,"ProductName":"Gustaf's Knäckebröd","UnitPrice":21.0,"UnitsInStock":104,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":5,"CategoryName":"Grains/Cereals"},"CategoryID":5,"QuantityPerUnit":"24 - 500 g pkgs."},{"ProductID":23,"ProductName":"Tunnbröd","UnitPrice":9.0,"UnitsInStock":61,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":5,"CategoryName":"Grains/Cereals"},"CategoryID":5,"QuantityPerUnit":"12 - 250 g pkgs."},{"ProductID":24,"ProductName":"Guaraná Fantástica","UnitPrice":4.5,"UnitsInStock":20,"Discontinued":true,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"12 - 355 ml cans"},{"ProductID":25,"ProductName":"NuNuCa Nuß-Nougat-Creme","UnitPrice":14.0,"UnitsInStock":76,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"20 - 450 g glasses"},{"ProductID":26,"ProductName":"Gumbär Gummibärchen","UnitPrice":31.23,"UnitsInStock":15,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"100 - 250 g bags"},{"ProductID":27,"ProductName":"Schoggi Schokolade","UnitPrice":43.9,"UnitsInStock":49,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"100 - 100 g pieces"},{"ProductID":28,"ProductName":"Rössle Sauerkraut","UnitPrice":45.6,"UnitsInStock":26,"Discontinued":true,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":7,"CategoryName":"Produce"},"CategoryID":7,"QuantityPerUnit":"25 - 825 g cans"},{"ProductID":29,"ProductName":"Thüringer Rostbratwurst","UnitPrice":123.79,"UnitsInStock":0,"Discontinued":true,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":6,"CategoryName":"Meat/Poultry"},"CategoryID":6,"QuantityPerUnit":"50 bags x 30 sausgs."},{"ProductID":30,"ProductName":"Nord-Ost Matjeshering","UnitPrice":25.89,"UnitsInStock":10,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"10 - 200 g glasses"},{"ProductID":31,"ProductName":"Gorgonzola Telino","UnitPrice":12.5,"UnitsInStock":0,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":70,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"12 - 100 g pkgs"},{"ProductID":32,"ProductName":"Mascarpone Fabioli","UnitPrice":32.0,"UnitsInStock":9,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":40,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"24 - 200 g pkgs."},{"ProductID":33,"ProductName":"Geitost","UnitPrice":2.5,"UnitsInStock":112,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"500 g"},{"ProductID":34,"ProductName":"Sasquatch Ale","UnitPrice":14.0,"UnitsInStock":111,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"24 - 12 oz bottles"},{"ProductID":35,"ProductName":"Steeleye Stout","UnitPrice":18.0,"UnitsInStock":20,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"24 - 12 oz bottles"},{"ProductID":36,"ProductName":"Inlagd Sill","UnitPrice":19.0,"UnitsInStock":112,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"24 - 250 g jars"},{"ProductID":37,"ProductName":"Gravad lax","UnitPrice":26.0,"UnitsInStock":11,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":50,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"12 - 500 g pkgs."},{"ProductID":38,"ProductName":"Côte de Blaye","UnitPrice":263.5,"UnitsInStock":17,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"12 - 75 cl bottles"},{"ProductID":39,"ProductName":"Chartreuse verte","UnitPrice":18.0,"UnitsInStock":69,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"750 cc per bottle"},{"ProductID":40,"ProductName":"Boston Crab Meat","UnitPrice":18.4,"UnitsInStock":123,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"24 - 4 oz tins"},{"ProductID":41,"ProductName":"Jack's New England Clam Chowder","UnitPrice":9.65,"UnitsInStock":85,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"12 - 12 oz cans"},{"ProductID":42,"ProductName":"Singaporean Hokkien Fried Mee","UnitPrice":14.0,"UnitsInStock":26,"Discontinued":true,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":5,"CategoryName":"Grains/Cereals"},"CategoryID":5,"QuantityPerUnit":"32 - 1 kg pkgs."},{"ProductID":43,"ProductName":"Ipoh Coffee","UnitPrice":46.0,"UnitsInStock":17,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":10,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"16 - 500 g tins"},{"ProductID":44,"ProductName":"Gula Malacca","UnitPrice":19.45,"UnitsInStock":27,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"20 - 2 kg bags"},{"ProductID":45,"ProductName":"Rogede sild","UnitPrice":9.5,"UnitsInStock":5,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":70,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"1k pkg."},{"ProductID":46,"ProductName":"Spegesild","UnitPrice":12.0,"UnitsInStock":95,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"4 - 450 g glasses"},{"ProductID":47,"ProductName":"Zaanse koeken","UnitPrice":9.5,"UnitsInStock":36,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"10 - 4 oz boxes"},{"ProductID":48,"ProductName":"Chocolade","UnitPrice":12.75,"UnitsInStock":15,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":70,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"10 pkgs."},{"ProductID":49,"ProductName":"Maxilaku","UnitPrice":20.0,"UnitsInStock":10,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":60,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"24 - 50 g pkgs."},{"ProductID":50,"ProductName":"Valkoinen suklaa","UnitPrice":16.25,"UnitsInStock":65,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"12 - 100 g bars"},{"ProductID":51,"ProductName":"Manjimup Dried Apples","UnitPrice":53.0,"UnitsInStock":20,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":7,"CategoryName":"Produce"},"CategoryID":7,"QuantityPerUnit":"50 - 300 g pkgs."},{"ProductID":52,"ProductName":"Filo Mix","UnitPrice":7.0,"UnitsInStock":38,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":5,"CategoryName":"Grains/Cereals"},"CategoryID":5,"QuantityPerUnit":"16 - 2 kg boxes"},{"ProductID":53,"ProductName":"Perth Pasties","UnitPrice":32.8,"UnitsInStock":0,"Discontinued":true,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":6,"CategoryName":"Meat/Poultry"},"CategoryID":6,"QuantityPerUnit":"48 pieces"},{"ProductID":54,"ProductName":"Tourtière","UnitPrice":7.45,"UnitsInStock":21,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":6,"CategoryName":"Meat/Poultry"},"CategoryID":6,"QuantityPerUnit":"16 pies"},{"ProductID":55,"ProductName":"Pâté chinois","UnitPrice":24.0,"UnitsInStock":115,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":6,"CategoryName":"Meat/Poultry"},"CategoryID":6,"QuantityPerUnit":"24 boxes x 2 pies"},{"ProductID":56,"ProductName":"Gnocchi di nonna Alice","UnitPrice":38.0,"UnitsInStock":21,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":10,"Category":{"CategoryID":5,"CategoryName":"Grains/Cereals"},"CategoryID":5,"QuantityPerUnit":"24 - 250 g pkgs."},{"ProductID":57,"ProductName":"Ravioli Angelo","UnitPrice":19.5,"UnitsInStock":36,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":5,"CategoryName":"Grains/Cereals"},"CategoryID":5,"QuantityPerUnit":"24 - 250 g pkgs."},{"ProductID":58,"ProductName":"Escargots de Bourgogne","UnitPrice":13.25,"UnitsInStock":62,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"24 pieces"},{"ProductID":59,"ProductName":"Raclette Courdavault","UnitPrice":55.0,"UnitsInStock":79,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"5 kg pkg."},{"ProductID":60,"ProductName":"Camembert Pierrot","UnitPrice":34.0,"UnitsInStock":19,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"15 - 300 g rounds"},{"ProductID":61,"ProductName":"Sirop d'érable","UnitPrice":28.5,"UnitsInStock":113,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"24 - 500 ml bottles"},{"ProductID":62,"ProductName":"Tarte au sucre","UnitPrice":49.3,"UnitsInStock":17,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"48 pies"},{"ProductID":63,"ProductName":"Vegie-spread","UnitPrice":43.9,"UnitsInStock":24,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"15 - 625 g jars"},{"ProductID":64,"ProductName":"Wimmers gute Semmelknödel","UnitPrice":33.25,"UnitsInStock":22,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":80,"Category":{"CategoryID":5,"CategoryName":"Grains/Cereals"},"CategoryID":5,"QuantityPerUnit":"20 bags x 4 pieces"},{"ProductID":65,"ProductName":"Louisiana Fiery Hot Pepper Sauce","UnitPrice":21.05,"UnitsInStock":76,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"32 - 8 oz bottles"},{"ProductID":66,"ProductName":"Louisiana Hot Spiced Okra","UnitPrice":17.0,"UnitsInStock":4,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":100,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"24 - 8 oz jars"},{"ProductID":67,"ProductName":"Laughing Lumberjack Lager","UnitPrice":14.0,"UnitsInStock":52,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"24 - 12 oz bottles"},{"ProductID":68,"ProductName":"Scottish Longbreads","UnitPrice":12.5,"UnitsInStock":6,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":10,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"10 boxes x 8 pieces"},{"ProductID":69,"ProductName":"Gudbrandsdalsost","UnitPrice":36.0,"UnitsInStock":26,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"10 kg pkg."},{"ProductID":70,"ProductName":"Outback Lager","UnitPrice":15.0,"UnitsInStock":15,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":10,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"24 - 355 ml bottles"},{"ProductID":71,"ProductName":"Flotemysost","UnitPrice":21.5,"UnitsInStock":26,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"10 - 500 g pkgs."},{"ProductID":72,"ProductName":"Mozzarella di Giovanni","UnitPrice":34.8,"UnitsInStock":14,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"24 - 200 g pkgs."},{"ProductID":73,"ProductName":"Röd Kaviar","UnitPrice":15.0,"UnitsInStock":101,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"24 - 150 g jars"},{"ProductID":74,"ProductName":"Longlife Tofu","UnitPrice":10.0,"UnitsInStock":4,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":20,"Category":{"CategoryID":7,"CategoryName":"Produce"},"CategoryID":7,"QuantityPerUnit":"5 kg pkg."},{"ProductID":75,"ProductName":"Rhönbräu Klosterbier","UnitPrice":7.75,"UnitsInStock":125,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"24 - 0.5 l bottles"},{"ProductID":76,"ProductName":"Lakkalikööri","UnitPrice":18.0,"UnitsInStock":57,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"500 ml"},{"ProductID":77,"ProductName":"Original Frankfurter grüne Soße","UnitPrice":13.0,"UnitsInStock":32,"Discontinued":false,"LastSupply":"2021-02-24T00:00:00+00:00","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"12 boxes"}],"Total":77}}});}); #configurator { width: 400px; min-width: 400px; display: inline-block; vertical-align: top; } #pivotgrid { width: 67%; display: inline-block; vertical-align: top; } .hidden-on-narrow { display: inline-block; vertical-align: top; }

Description

This demo for ASP.NET Core PivotGrid component shows how you can populate i twith local flat data. The demo features filtering and sorting of rows and columns. To sort the PivotGrid rows and columns, click on the fields in the headers, the field menu or use the PivotGrid Configurator.

To enable the sortable functionality, use the Sortable() method.

Support & Learning Resources

Was this demo helpful?

YES NO

Tell us how we can improve this demo

Submit Skip