Hello..
Can i get one example for Three level hierarchy in Gridview?
grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates.Add(packageTemplate);
GridViewRelation packageRelation = new GridViewRelation(grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0]);
I am using the above code for adding third level.unfortunetly i am not getting the third leve.
Pls help me
thanks in advance
Can i get one example for Three level hierarchy in Gridview?
grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates.Add(packageTemplate);
GridViewRelation packageRelation = new GridViewRelation(grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0]);
I am using the above code for adding third level.unfortunetly i am not getting the third leve.
Pls help me
thanks in advance
2 Answers, 1 is accepted
0
Hello anoop,
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
When you create relation between parent/child templates, you must add it to RadGridView Relations collection.
gridView.Relations.Add(relation);
Please view our Examples demo application - RadGridView >> Hierarchy section. For additional information about the process of manually configuring a hierarchy in RadGridView, please refer to our online help.
Sincerely yours,
Julian Benkovthe Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0

anoop
Top achievements
Rank 1
answered on 24 Mar 2010, 11:48 AM
Thanks for the reply.Here my whole code, i have added two realation to the gridview..
objstockinquiry.Filter = chkActiveParts.Checked;
objstockinquiry.selectRecord();
grvStcokInquiry.DataSource = objstockinquiry.dt_invsummary;
GridViewTemplate detailTemplate = new GridViewTemplate();
detailTemplate.DataSource = objstockinquiry.dt_invdetail;
grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates.Add(detailTemplate);
GridViewRelation invrelation = new GridViewRelation(grvStcokInquiry.MasterGridViewTemplate);
invrelation.ChildTemplate = detailTemplate;
invrelation.RelationName = objstockinquiry.Relations[1].RelationName;
invrelation.ParentColumnNames.Add("part_uid");
invrelation.ChildColumnNames.Add("part_uid");
grvStcokInquiry.Relations.Add(invrelation);
GridViewTemplate packageTemplate = new GridViewTemplate();
packageTemplate.DataSource = objstockinquiry.dt_package_details;
grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates.Add(packageTemplate);
GridViewRelation packageRelation = new GridViewRelation(grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0]);
packageRelation.ChildTemplate = packageTemplate;
packageRelation.RelationName = objstockinquiry.Relations[0].RelationName;
packageRelation.ParentColumnNames.Add("part_uid");
packageRelation.ParentColumnNames.Add("lotno");
packageRelation.ParentColumnNames.Add("sub_inv_uid");
packageRelation.ParentColumnNames.Add("batchcode");
packageRelation.ChildColumnNames.Add("part_uid");
packageRelation.ChildColumnNames.Add("lotno");
packageRelation.ChildColumnNames.Add("sub_inv_uid");
packageRelation.ChildColumnNames.Add("batchcode");
grvStcokInquiry.Relations.Add(packageRelation);
this.grvStcokInquiry.MasterGridViewTemplate.Columns["part_uid"].IsVisible = false;
this.grvStcokInquiry.MasterGridViewTemplate.Columns["part_id"].HeaderText = "Part ID";
this.grvStcokInquiry.MasterGridViewTemplate.Columns["part_description"].HeaderText = "Description";
this.grvStcokInquiry.MasterGridViewTemplate.Columns["rev_level"].HeaderText = "Level";
this.grvStcokInquiry.MasterGridViewTemplate.Columns["safety_stock"].HeaderText = "Safety Stock";
this.grvStcokInquiry.MasterGridViewTemplate.Columns["current_stock"].HeaderText = "Current Stock";
this.grvStcokInquiry.MasterGridViewTemplate.Columns["unverified_txn_qty"].HeaderText = "Unverified Qty";
this.grvStcokInquiry.MasterGridViewTemplate.Columns["nettable_qty"].HeaderText = "Nettable Qty";
this.grvStcokInquiry.MasterGridViewTemplate.Columns["non_nettable_qty"].HeaderText = "NonNettable Qty";
this.grvStcokInquiry.MasterGridViewTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].Columns["part_uid"].IsVisible = false;
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].Columns["lotno"].HeaderText = "Lot Number";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].Columns["batchcode"].HeaderText = "Batch Code";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].Columns["current_stock"].HeaderText = "Current Stock";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].Columns["receipt_date"].HeaderText = "Receipt Date";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].Columns["sub_inv_uid"].IsVisible = false;
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].Columns["sub_inv_code"].HeaderText = "Sub Inventory Code";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].Columns["nettable"].HeaderText = "Nettable";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates[0].Columns["part_uid"].IsVisible = false;
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates[0].Columns["sub_inv_uid"].IsVisible = false;
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates[0].Columns["package_id"].HeaderText = "Package ID";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates[0].Columns["container_id"].HeaderText = "Container ID";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates[0].Columns["qty"].HeaderText = "Qunatity";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates[0].Columns["part_id"].HeaderText = "Part ID";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates[0].Columns["lotno"].HeaderText = "Lot Number";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates[0].Columns["batchcode"].HeaderText = "Batch Code";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates[0].AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
objstockinquiry.Filter = chkActiveParts.Checked;
objstockinquiry.selectRecord();
grvStcokInquiry.DataSource = objstockinquiry.dt_invsummary;
GridViewTemplate detailTemplate = new GridViewTemplate();
detailTemplate.DataSource = objstockinquiry.dt_invdetail;
grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates.Add(detailTemplate);
GridViewRelation invrelation = new GridViewRelation(grvStcokInquiry.MasterGridViewTemplate);
invrelation.ChildTemplate = detailTemplate;
invrelation.RelationName = objstockinquiry.Relations[1].RelationName;
invrelation.ParentColumnNames.Add("part_uid");
invrelation.ChildColumnNames.Add("part_uid");
grvStcokInquiry.Relations.Add(invrelation);
GridViewTemplate packageTemplate = new GridViewTemplate();
packageTemplate.DataSource = objstockinquiry.dt_package_details;
grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates.Add(packageTemplate);
GridViewRelation packageRelation = new GridViewRelation(grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0]);
packageRelation.ChildTemplate = packageTemplate;
packageRelation.RelationName = objstockinquiry.Relations[0].RelationName;
packageRelation.ParentColumnNames.Add("part_uid");
packageRelation.ParentColumnNames.Add("lotno");
packageRelation.ParentColumnNames.Add("sub_inv_uid");
packageRelation.ParentColumnNames.Add("batchcode");
packageRelation.ChildColumnNames.Add("part_uid");
packageRelation.ChildColumnNames.Add("lotno");
packageRelation.ChildColumnNames.Add("sub_inv_uid");
packageRelation.ChildColumnNames.Add("batchcode");
grvStcokInquiry.Relations.Add(packageRelation);
this.grvStcokInquiry.MasterGridViewTemplate.Columns["part_uid"].IsVisible = false;
this.grvStcokInquiry.MasterGridViewTemplate.Columns["part_id"].HeaderText = "Part ID";
this.grvStcokInquiry.MasterGridViewTemplate.Columns["part_description"].HeaderText = "Description";
this.grvStcokInquiry.MasterGridViewTemplate.Columns["rev_level"].HeaderText = "Level";
this.grvStcokInquiry.MasterGridViewTemplate.Columns["safety_stock"].HeaderText = "Safety Stock";
this.grvStcokInquiry.MasterGridViewTemplate.Columns["current_stock"].HeaderText = "Current Stock";
this.grvStcokInquiry.MasterGridViewTemplate.Columns["unverified_txn_qty"].HeaderText = "Unverified Qty";
this.grvStcokInquiry.MasterGridViewTemplate.Columns["nettable_qty"].HeaderText = "Nettable Qty";
this.grvStcokInquiry.MasterGridViewTemplate.Columns["non_nettable_qty"].HeaderText = "NonNettable Qty";
this.grvStcokInquiry.MasterGridViewTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].Columns["part_uid"].IsVisible = false;
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].Columns["lotno"].HeaderText = "Lot Number";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].Columns["batchcode"].HeaderText = "Batch Code";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].Columns["current_stock"].HeaderText = "Current Stock";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].Columns["receipt_date"].HeaderText = "Receipt Date";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].Columns["sub_inv_uid"].IsVisible = false;
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].Columns["sub_inv_code"].HeaderText = "Sub Inventory Code";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].Columns["nettable"].HeaderText = "Nettable";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates[0].Columns["part_uid"].IsVisible = false;
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates[0].Columns["sub_inv_uid"].IsVisible = false;
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates[0].Columns["package_id"].HeaderText = "Package ID";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates[0].Columns["container_id"].HeaderText = "Container ID";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates[0].Columns["qty"].HeaderText = "Qunatity";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates[0].Columns["part_id"].HeaderText = "Part ID";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates[0].Columns["lotno"].HeaderText = "Lot Number";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates[0].Columns["batchcode"].HeaderText = "Batch Code";
this.grvStcokInquiry.MasterGridViewTemplate.ChildGridViewTemplates[0].ChildGridViewTemplates[0].AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;