Hey Lyuba,

Thank you for your response.

However, I don't see any load-on-demand happening at the child level with your sample code. The data for the child level is retrieved and loaded into the dataset along with the parent data.

This would definitely perform bad when the data at the lower levels are huge. In my case, I have 4 levels of hierarchy. The total records at the 4 level could run into thousands to millions. I would like to get data for the lower level only when the parent row is expanded using code-behind architecture. How do I achieve this?

I appreciate your response!

Thanks