jube-fork/Jube.App/wwwroot/kendo/examples/grid/foreignkeycolumn.html

<!DOCTYPE html>
<html>
<head>
    <title>ForeignKey column</title>
    <meta charset="utf-8">
    <link href="../content/shared/styles/examples-offline.css" rel="stylesheet">
    <link href="../../styles/kendo.common.min.css" rel="stylesheet">
    <link href="../../styles/kendo.rtl.min.css" rel="stylesheet">
    <link href="../../styles/kendo.default.min.css" rel="stylesheet">
    <link href="../../styles/kendo.default.mobile.min.css" rel="stylesheet">
    <script src="../../js/jquery.min.js"></script>
    <script src="../../js/jszip.min.js"></script>
    <script src="../../js/kendo.all.min.js"></script>
    <script src="../content/shared/js/console.js"></script>
    <script>
        
    </script>
    
    
</head>
<body>
    
        <a class="offline-button" href="../index.html">Back</a>
    
    <script src="../content/shared/js/products.js" type="text/javascript"></script>
<div id="example">
    <div id="grid"></div>

    <script>
        var categories = [{
            "value": 1,
            "text": "Beverages"
        },{
            "value": 2,
            "text": "Condiments"
        },{
            "value": 3,
            "text": "Confections"
        },{
            "value": 4,
            "text": "Dairy Products"
        },{
            "value": 5,
            "text": "Grains/Cereals"
        },{
            "value": 6,
            "text": "Meat/Poultry"
        },{
            "value": 7,
            "text": "Produce"
        },{
            "value": 8,
            "text": "Seafood"
        }];

        $(document).ready(function () {
            var dataSource = new kendo.data.DataSource({
                pageSize: 20,
                data: products,
                autoSync: true,
                schema: {
                    model: {
                        id: "ProductID",
                        fields: {
                            ProductID: { editable: false, nullable: true },
                            ProductName: { validation: { required: true} },
                            CategoryID: { field: "CategoryID", type: "number", defaultValue: 1 },
                            UnitPrice: { type: "number", validation: { required: true, min: 1} }
                        }
                    }
                }
            });

            $("#grid").kendoGrid({
                dataSource: dataSource,
                filterable: true,
                groupable: true,
                pageable: true,
                height: 540,
                toolbar: ["create"],
                columns: [
                    { field: "ProductName", title: "Product Name" },
                    { field: "CategoryID", width: "200px", values: categories, title: "Category" },
                    { field: "UnitPrice", title: "Unit Price", format: "{0:c}", width: "200px" },
                    { command: "destroy", title: " ", width: "150px"}],
                editable: true
            });
        });
    </script>
</div>


    
</body>
</html>