GridView-Master-Child Relation

[sagar]

Problem :
The Child records in Winforms radgrid hierarchy should show at the first click expand and it shouldn't collapse automatic.

At  Design Time, I create Strongly Typed dataset containing two tables
Master table--Company
Child Table---Branch
having Relation in these tables by "Company Id"

At Form load , if we use "AutoGenerateHierarchyFromDataSet" , it takes More time
as it has  almost 10000 Company Records and 40000 Branch Records.I think The RadGrid  take time to rearrange the records according To hierarchy.

So I tried another alternative:
At time of loading the form ,I fill only Company table.
When I expand any Company ID row, I fill the Branch table only for selected(Iscurrent row) Company Id .Then refresh the Radgrid by
radGrid.Rows(RowIndex).ViewInfo.UpdateView()
As well as
radGrid.GridElement.Update(True)

But the problem is, when i expand the row first time ,The row expands, But does't show branch records for current row Comapny ID.After some time the row automatically collapse.
When I expand ,the same row second time ,it shows the branch(child) records .

This on demand fascility will be helpful for handling large data.

Kindly see in this.
Thanks
sagar
 

[Julian Benkov]

Hi Sagar,

Thank you for writing.

We planned to implement the on demand loading feature for RadGridView soon after our Q1 2008 release. This week we will release a beta edition of the improved RadGridView with a new hierarchy engine. The loading time is significantly decreased and we have added a new model for refreshing data in child templates.

If you have any other questions, please contact us.

All the best,
Julian Benkov
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[sagar]

Hi Julian

Thanking for this information.
I am  waiting  for this upadte as I am badly need it in our Project.

One more suggestion :

Private

Sub radGrid_CurrentRowChanged(ByVal sender As Object, ByVal e As Telerik.WinControls.UI.CurrentRowChangedEventArgs) Handles radGridContacts.CurrentRowChanged

MsgBox( radGrid.Rows(radGrid.Rows.IndexOf(e.CurrentRow)))
End Sub

It should show the rowindex of that current row in CurrentRowChanged Event.But it Shows "-1" every times.

kind regards,
sagar

[Julian Benkov]

Hi Sagar,

Thank you for suggestion.

For new edition of RadGridView, the GridViewRowCollection is refactored. New events have been added, such as RowChanging/RowChanged and rowindex that reference the current row position in the current view after all operations such as sort, grouping and filtering have been applied.

I hope this helps. If you have any other questions, please contact me.

All the best,
Julian Benkov
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[sagar]

Hi Julian

For datagridview  most important feature that any win developer wants

1. Events For Hierarchial grid :
            1.BeforeRowCollapsed and AfterRowCollapsed
            2.BeforeRowExpanded and AfterRowExpanded

2.Filter Capability from child to Parent :
   That means if we give filter criteria for child grid ,then master grid should     show only those master record containing those filtered child row.

3. Freezed column capability.

This make the grid more powerful.          
Hope U will implement it as early as possible.

Kind regards,
sagar

[Julian Benkov]

Thank you for the feedback, Sagar. These are on our ToDo list and will appear in RadGridView soon.

Thank you for all your suggestions.

 
Sincerely yours,
Julian Benkov
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center