Hello Rick,

The LoadOnDemand feature has been around since early WebCombo version and it is made available in order to meet the growing complexity of business requirements.
One of these requirements is, for instance, controlling data retrieval precisely based on user action from a large data source.

LoadOnDemand allows developers to write their own code to control data rows needed to be retrieved from physical data source based on provided server event argument.
This provides total solution of data selection for applications with large data source .

To enable LoadOnDemand data retrieval mechanism, you need to set AllowAutoQueryHandler property to False.
With this property set to False, the WebCombo will not perform the automatic (default behavior) query handling.
Therefore, you need to write your own code for your specific data-retrieval scenario in InitializeDataSource event.

For large data, we do suggest to use LoadOnDemand. Otherwise, how can you show 100,000 records at once in a list or dropdownlist box? 

Regards,
Handy

Thank you for the response. Since this particular data does not change very often, is there another option where I can create and XML file (on the local machine or on a shared drive) of the data so that it avoid the initial load?

If there is no other option I will investigate setting up Load on Demand, it's just that it takes a fair amount of work to set it up.

Thanks Again,

Rick

Hi Rick,

I am sorry but I don't quite understand about "can create and XML file" part.
If you want to avoid to be loaded at the initial load, you can use loadOnDemand. 

Regards,
Handy