Need to bind SIMPLE dropdown in MVC core grid , having Y and N value

[Praveen]

There will be a Grid in my application, i need to create a dropdown column which will have Y and N as values 

No need to fetch these Y and N values from server side 

Please comment how it will be done

Thanks in advance 

Praveen

[Thavasianand Sankaranarayanan]

Hi Praveen, 

Greetings from Syncfusion. 

We can achieve your requirement using the load event and edit property in Grid. In the below code example we have bind local data for “Verified“ column in Grid. 

<ejs-grid id="Grid" dataSource="ViewBag.dataSource" allowPaging="true" load="load" > 

    <e-grid-editSettings allowAdding="true" allowDeleting="true" allowEditing="true"></e-grid-editSettings> 

    <e-grid-columns> 

        <e-grid-column field="OrderID" headerText="Order ID" isPrimaryKey="true" textAlign="Right" width="100"></e-grid-column> 

        <e-grid-column field="CustomerID" headerText="Customer ID" width="100"></e-grid-column> 

        <e-grid-column field="Freight" width="100" format="C5"></e-grid-column> 

        <e-grid-column field="Verified" headerText="Verified" width="100"></e-grid-column> 

        <e-grid-column field="OrderDate" headerText="Order Date" width="90" format="yMd"></e-grid-column> 

    </e-grid-columns> 

</ejs-grid> 

 

<script> 

    var dropDownData = [{ "Verified": "Y", "SNO": 1 }, { "Verified": "N", "SNO": 2 }]; 

 

    function load(args) { 

 

        this.columns[3].edit = { 

 

            create: function () { 

                elem = document.createElement('input'); 

                return elem; 

            }, 

            read: function () { 

                return dropdownObj.value; 

            }, 

            destroy: function () { 

                dropdownObj.destroy(); 

            }, 

            write: function (args) { 

                dropdownObj = new ej.dropdowns.DropDownList({ 

                    dataSource: dropDownData, 

                    fields: { text: "Verified", value: "Verified" }, 

                    value: args.rowData[args.column.field] 

                }); 

                dropdownObj.appendTo(elem); 

            } 

        } 

    } 

</script> 

Refer the help documentation. 

Link: https://ej2.syncfusion.com/javascript/documentation/api/grid/#load 

Link: https://ej2.syncfusion.com/javascript/documentation/api/grid/column/#edit 

Please let us know if you need further assistance on this. 

  

Regards, 

Thavasianand S.