igGrid - LoadOnDemand with RowEditDialog

2350

Paul Decristoforo posted over 7 years ago

Hello,

We currently have many grids use a RowEditDialog for editing/adding records. Foreign keys for these grids are converted into combo boxes and are linked to a remote data source using the DataSourceUrl. When the RowEditDialog is loaded in edit mode, we do have some custom code that sets the initial value of the comboboxes to what's in the grid because this is not getting loaded automatically for some reason (i've attached the custom code we are using to do this). This all works fine; however, when we try to implement LoadOnDemand with our comboboxes, the values are not getting set properly. This happens when the currently selected value is not in the first page. We would like to use LoadOnDemand as some of our foreign keys can have up to 100k rows.

Do you have a recommended way for accomplishing this? Is there a way to page to the currently selected value so that we can set the initial combo value?

Thanks,

Paul

Parents

No Data

Reply

25665

Offline Michael Peterson posted over 7 years ago

Hello Paul,

Thank you for contacting Infragistics!

How are you setting up the grid/combo? I would recommend setting it up through the editorOptions, this way you should be able to set the dataSourceUrl through this way and the dialog/combo should grab the value from the grid instead of writing custom code:

https://www.igniteui.com/help/api/2017.1/ui.iggridupdating#options:columnSettings.editorOptions

https://www.igniteui.com/help/api/2017.1/ui.igcombo#options:dataSourceUrl

What version are you using?
Do you have an isolated sample that demonstrates the behavior you are seeing?
Cancel
Reply

Cancel

Children

2350

Offline Paul Decristoforo posted over 7 years ago in reply to Michael Peterson

Hi Mike,

We are building the grid through MVC. Unfortunately, I do not have an isolated sample and I'm doing this in version 17.1. I think part of the issue is that I'm using a key value pair here. We build a flattened view that displays the "Code" in the grid and then have the "Id" field hidden on the initial view. When a user edits the row, the "Code" field is hidden, and the "Id" field is what they edit (which is a dropdown). We've been using this approach for a while now and I'm not sure if there is a better way to do this now. Below is what the final markup looks like for one of my columns:

{

columnIndex: -1,

columnKey: 'SeparateAccountId',

required: true,

editorType: 'combo',

editorOptions: {

filterExprUrlKey: 'filter',

compactData: true,

textKey: 'Value',

valueKey: 'Key',

enableClearButton: false,

validatorOptions: {

required: {

errorMessage: 'This field is required.'

},

requiredIndication: true

},

virtualization: true,

dataSourceUrl: '/Home/GetDistict_Generic?a_TableProperty=SeparateAccounts&a_Property=SeparateAccountCode&a_ExtendedProperties=Company.CompanyCode',

loadOnDemandSettings: {

enabled: false

},

dataSource: null

}

}

[ComboDataSourceAction()]

[Authorize]

public ActionResult GetDistict_Generic(string a_TableProperty, string a_Property, string a_ExtendedProperties, string path, string filter,)

{

IList<ComboDataViewModel> results = new List<ComboDataViewModel>();

...

return View(results.AsQueryable());

}

Thanks,

Paul
Cancel
Reply

Cancel