MultiColumnComboBoxFor - Showing DataValue instead of DataText with large dataset

[Stefan]

We have use a MultiColumnComboBoxFor to select from a large dataset > 100.000 records.

At the time of selecting a record the DataText is correctly displayed.

But when we refresh the page the ComboBox behaves differently for records which appear early in the dataset, and records that come later.

The early records show the DataText correctly, records which come later in the dataset do not; they show their Id (DataValue).

 

If we implement virtualization, the Combobox displays the correct DataText in both cases, but seemingly with an extra server roundtrip?

 

Is this expected behaviour? Is there anything we could improve while using the MultiColumnComboBox with larger datasets?

 

Kind regards.

[Mihaela]

Hello Stefan,

The described behavior is expected when the MultiColumnComboBox loads a large dataset. For this reason, when working with huge amounts of data, we recommend enabling the virtualization feature. This way, when the page is refreshed, the component sends a request to the server to retrieve the selected option's data item by using its value (DataValueField), so the DataTextField is displayed as expected.

If you have any particular questions related to the virtualization or how to set it up, please let me know.

Regards,
Mihaela
Progress Telerik