Gridview Cascaded Dropdownlists

[jack]

Hello, 

I am working on creating a dynamic Grid In MVC with adding rows with cascaded dropdownlists.

Please if you have a sample on cascaded dropdownlists in Grid/edit and add, 

i am using below code in Generating dropdownlist but couldn't tell how to filter Dropdownlist based on  DropDownListCategory  :

 @{

                        var DropDownList = new Syncfusion.EJ2.DropDowns.DropDownList() { DataSource = ViewBag.Items, Query = "new ej.data.Query()", AllowFiltering = true, Fields = new Syncfusion.EJ2.DropDowns.DropDownListFieldSettings() { Value = "Id", Text = "ItemDescription" } };

                        var DropDownListCategory = new Syncfusion.EJ2.DropDowns.DropDownList() { DataSource = ViewBag.Categories, Query = "new ej.data.Query()", AllowFiltering = true, Fields = new Syncfusion.EJ2.DropDowns.DropDownListFieldSettings() { Value = "id", Text = "ItemCategory1" } };

                    }

   @Html.EJS().Grid("InlineEditing").DataSource((IEnumerable<object>)ViewBag.Orders).Columns(col =>

               {

                   col.Field("Id").HeaderText("OrderID").Width("140").ValidationRules(new {number = true }).TextAlign(Syncfusion.EJ2.Grids.TextAlign.Right).Add();

                   col.Field("CategoryID").HeaderText("CategoryID").Width("150").ValidationRules(new { required = true, minLength = 3 }).EditType("dropdownedit").Edit(new { @params = DropDownListCategory }).Add();

                   col.Field("Itemid").HeaderText("Itemid").Width("150").ValidationRules(new { required = true, minLength = 3 }).EditType("dropdownedit").Edit(new { @params = DropDownList }).Add();

                   col.Field("Qty").HeaderText("Qty").Width("140").EditType("numericedit").ValidationRules(new { required = true }).Format("C2").TextAlign(Syncfusion.EJ2.Grids.TextAlign.Right).Add();

                   col.Field("AgencyLotNumber").HeaderText("LotNumber").Width("140").TextAlign(Syncfusion.EJ2.Grids.TextAlign.Right).Add();

                   col.Field("ProducerLotNumber").HeaderText("ProducerLotNumber").Width("140").TextAlign(Syncfusion.EJ2.Grids.TextAlign.Right).Add();

               }).ActionBegin("actionBegin").AllowPaging().PageSettings(page => page.PageCount(2)).EditSettings(edit => { edit.AllowAdding(true).AllowEditing(true).AllowDeleting(true).Mode(Syncfusion.EJ2.Grids.EditMode.Normal); }).Toolbar(new List<string>() { "Add", "Edit", "Delete", "Update", "Cancel" }).Render()

Thank you,

Best Regards,

[Sujith Kumar Rajkumar]

Hi Jack, 

 

Greetings from Syncfusion support. 

 

We have already documented the mentioned requirement of initializing cascading dropdown list for Grid edit and you can check the same from the below link, 

 

https://ej2.syncfusion.com/aspnetmvc/documentation/grid/how-to/cascading-drop-down-list-with-grid-editing 

 

We have also prepared a local MVC Grid sample to demonstrate this case for your reference. You can find it below, 

 

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/GridCascadingDropdownlist-286210921 

 

Please get back to us if you require any further assistance. 

 

Regards, 

Sujith R