Problem using HierarchyLoadMode Client

[A]

Hello,
I have a hierarchy grid with one nested level.
I'm having some issues with HierarchyLoadMode setting set to Client on my grid.
I load my grid on during Page_Load event, and it is loaded without any issues.
After that, the event to load the DetailTable is called:

protected void RadGrid1_DetailTableDataBind(object source, Telerik.Web.UI.GridDetailTableDataBindEventArgs e)
        {
           GridDataItem dataItem = (GridDataItem)e.DetailTableView.ParentItem;
           string paramID = dataItem.GetDataKeyValue("Param_Id").ToString();
            string sConnectionString = "My Connection String";

            SQLDataSource1.SelectParameters["ModelIdParam"].DefaultValue = paramID ;
                SQLDataSource1.ConnectionString = sConnectionString;

                e.DetailTableView.DataBind();
        }

I get an exception - +  ex {"Invalid attempt to call FieldCount when reader is closed."} 

I am not sure what I'm doing wrong, because if I don't set hierarchyModeLoad to Client, the exact same code runs without any issues, and I can expand/collapse the rows.

I would appreciate any help.

[Tsvetina]

Hello,

This exception is thrown when you try to either use a DataReader instance after it has already been closed or have one DataReader used by two controls.

Please note that as DataReader object can be read only forward, when iterated once you cannot read it again. Therefore, if you are using one DataReader to bind both the DetailTable and the MasterTableView, one solution to the problem could be to fill some kind of container object (datatable, custom object etc.) and bind the tableviews to it instead to the DataReader.

If this is not the case, you should make sure that you are not closing the DataReader too early. An appropriate place to close the DataReader and the connection is in the DataBound event handler of the RadGrid.

Regards,
Tsvetina
the Telerik team

[Vinit]

Hi ,
  I got an issue when I use Hierarchy load mode as 'client". when my hierarchical grid is in ASPX page with client load mode, It work fine.
Expand collapse works fine.But when I put the same code in the user control , then with "client" hierarchy load mode expand column does not work. We just can't see the detail table.

If I change the load mode to the serverOnDemand / serverbind It works .

I have attached the file.

Please guide me , not able to understand why this is happening.

Regards
Vinit