Hi,

I just looked into the IsEmptyParent, but I'm not sure what you're suggesting to do with it. Which method do you suggest for getting just the records I need?  I really like the idea of altering the sql selectcommand in the rowislanddatabinding event.  I need to get my key field from the parent row which I can't seem to get.  I tried using e.RowIsland.ParentRow but it's always nothing in the rowislanddatabinding event.

Thanks, Ed

Hi,

Yes, and I have used that in other parts of my site. In this case though, I have many thousands of records and the initial load is unacceptable as well as the paging loads. Once, we figure out a good way to do some smart data selecting, I would actually want to load all the data and child data for an entire page at a  time.

Either way, the InitialDataBindDepth is a helpful property to be mentioned in this post.

Thanks, Ed

Hi,

This is an important post.  I think some of the developers should weigh in on this one.  It's extremely limiting of the WHDG to constantly select the entire database.

Thanks, Ed

The reason the grid hits every row's children is that it has to know whether the row has any children and whether the expansion indicator needs to be rendered.

Just like Dave suggested I can point you to using the manual load on demand, and the IsEmptyParent can be played with to instruct every row if it is supposed to have child rows. Although I'd imsagine you on your own will have to touch the db to figure out that.

If the property is left untouched the indicator will appear on every row in the manual mode, then clicking it will do nothing for childless rows.

Hi,

The only event which seems to expose the isemptyparent property is the rowexpanded event.  How would I use this to render the expansion indicator on the initialize row event?

Although I have been able to set up the manual load on demand, I don't understand how I could ever create logic to find children of a row manually (which would mean that I have some piece of info about the parent) and still be able to set the expansion indicator at that point in time.  Is the data of the row available to me before the rendering of the expansion indicator?

Thanks, Ed

Well I guess that is the trick here.. Just like the grid does in the automatic mode you would have to ping the child table to see if there are any related child rows for each parent row.

Setting the property oin the parent's InitializeRow should be well in advance of rendering of the indicator.

I am having problems as well with perfomance and editing. I found that when I am using the LoadOnDemand whith no DataSources in markup and creating everything inside RowIslandsPopulating this does solve the multiple "getAll" queries.

My problem comes in when I try and do an update inside a child row, are you doing updates in a child or parent row?

I get an "Object reference not set to an instance of an object" ......

Any thoughts on this?

I've been playing around with this, and had one large problem - something is missing when you create a new containerGrid - when any cells in the new rows are updated there is a "not implemented" error on the client side (the update may or may not go through). Something appears to be not quite linked between the containerGrid bound server side and the requirements of the grid client side to save (despite it working fine when everything was bound using only the default "getAll" queries)

Any ideas?

I also notice that the grid internally still calls the default "getall" query in the hierarchical data markup on the page, sometime MULTIPLE times before it then calls the RowIslandsPopulating event server side. While I commented out the sever side ftn so it didn't return any rows, it is a concern - no wonder it runs slowly.

I found that you can do something like this

        ContainerGrid childGrid = new ContainerGrid();
        childGrid.Band = WebHierarchicalDataGrid1.Bands[0];
        e.Row.RowIslands.Add(childGrid);

if you have an existing band declared in markup, athough it gives me a casting error if I try and expand multiple bands at a time.

hi

i tried above code but no expansion indicator in the webHierarchicalDataGrid, i am also trying same thing  manual load on demand.

if there is any other options...

thanks

Srikanth

The example in the help file for manually populating the island in the RowIslandsPopulating event looks like the following:

// Create Container Grid
ContainerGrid childGrid = new ContainerGrid();
e.Row.RowIslands.Add(childGrid);

// Bind Grid
childGrid.DataSource = products;
childGrid.DataBind();

Instead of creating a new ContainerGrid, can I somehow use an 

existing band and bind to that instead in the 

RowIslandsPopulating event? 

<Bands>
   <ig:Band AutoGenerateColumns="false" Key="TXN" >
     <Columns>
       <ig:BoundDataField DataFieldName="TXN_CD" Key="TXN_CD" 

Header-Text="Transaction Code" />                                            
       <ig:BoundDataField DataFieldName="ISSUED_DT" Key="ISSUED_DT" 

Header-Text="Issue Date"/>
     </Columns>
   </ig:Band>
</Bands>