This is a migrated thread and some comments may be shown as answers.

RadGridView Self-Reference Hierarchy questions

5 Answers 62 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Dilshod
Top achievements
Rank 1
Dilshod asked on 30 Jun 2018, 08:02 AM

Hello,

I have a couple questions related to RadGridView Self-Reference Hierarchy:

1. Is there a way to use the properties of System.Guid type as parent/child IDs? or only Int type?
2. How to configure a grid to be able to specify the columns manually and set AutoGenerateColumns property to false. I was not able to achieve it.

Thanks in advance!

5 Answers, 1 is accepted

Sort by
0
Dilshod
Top achievements
Rank 1
answered on 01 Jul 2018, 11:51 AM

Additional questions:

3. Why pinned columns ignore RowFormatting event? For example, BackColor value.

4. If grid is set up as AutoSizeRows = true, pinned column is word wrapped and contains multi-lined text, non pinned columns' row height does not equal to pinned row height. Why?

5. If grid is set up using Column Groups, then pinned and unpinned rows have different row heights. when grid.AutoSizeRows = true

 

0
Dilshod
Top achievements
Rank 1
answered on 18 Jul 2018, 06:41 AM

Hello,

Can I get any answers on my questions?

0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 18 Jul 2018, 09:16 AM
Hello, Dilshod,    

Note that most of the forum threads are reviewed by Telerik representatives and sometimes we address the questions asked by our customers in the forums as well. However, a post in the forum doesn't guarantee you a response from the Telerik support team. Moreover, threads are handled according to license and time of posting, so if it is an urgent problem, we suggest you use a support ticket, which would be handled before a forum thread. 

As a  gesture of good will we will adress your questions:

1. You can use Guid for parent id/ child id when building a self- reference hierarchy. It is important just to add properly the self-reference relation. Additional information is available in the following help article: https://docs.telerik.com/devtools/winforms/gridview/hierarchical-grid/self-referencing-hierarchy

2. When the AutoGenerateColumns property is set to false and you add manually the columns note that it is important to specify the FieldName property to the respective field in the DataSource. You can find below a sample code snippet:

DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(Guid));
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("ParentId", typeof(Guid));
 
Guid id = Guid.NewGuid();
Guid parentId = Guid.NewGuid();
dt.Rows.Add(id, "Row1", parentId);
id = Guid.NewGuid();
dt.Rows.Add(id, "Row2", parentId);
parentId = id;
id = Guid.NewGuid();
dt.Rows.Add(id, "Row3", parentId);
 
this.radGridView1.AutoGenerateColumns = false;
 
GridViewTextBoxColumn textBoxColumn = new GridViewTextBoxColumn("Id");
textBoxColumn.FieldName = "Id";
radGridView1.MasterTemplate.Columns.Add(textBoxColumn);
 
GridViewTextBoxColumn textBoxColumn2 = new GridViewTextBoxColumn("Name");
textBoxColumn2.FieldName = "Name";
radGridView1.MasterTemplate.Columns.Add(textBoxColumn2);
 
GridViewTextBoxColumn textBoxColumn3 = new GridViewTextBoxColumn("ParentId");
textBoxColumn3.FieldName = "ParentId";
radGridView1.MasterTemplate.Columns.Add(textBoxColumn3);
 
this.radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
 
this.radGridView1.Relations.AddSelfReference(this.radGridView1.MasterTemplate, "Id", "ParentId");
this.radGridView1.DataSource = dt;


3. Since CellFormatting/RowFormatting events are fired only for the data cells/rows, the ViewCellFormatting/ViewRowFormatting events are fired for all cells/rows. Thus, you can customize the desired cells/ rows. Additional information is available in the following help articles: 
https://docs.telerik.com/devtools/winforms/gridview/cells/formatting-cells
https://docs.telerik.com/devtools/winforms/gridview/rows/formatting-rows 

4.5. When the AutoSizeRows property is set to true, the row height depends on the content that is displayed in the row. Whether the text will be wrapped or not is controlled by the GridViewColumn.WrapText property.

I hope this information helps. If you have any additional questions, please let me know.  
 
Regards,
Dess
Progress Telerik
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Dilshod
Top achievements
Rank 1
answered on 21 Dec 2018, 12:02 PM

Hello, Dess,

I realized what is the problem with Self-Reference Hierarchy when AutoGenerateColumns property is set to false. The Grid requires "ParentID" and "ID" columns to be specified! This is not documented and confused.

And if you change your code to next view then it will not work (just remved ID and ParentID columns from columns list which is common for most cases in real applications):

DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(Guid));
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("ParentId", typeof(Guid));
  
Guid id = Guid.NewGuid();
Guid parentId = Guid.NewGuid();
dt.Rows.Add(id, "Row1", parentId);
id = Guid.NewGuid();
dt.Rows.Add(id, "Row2", parentId);
parentId = id;
id = Guid.NewGuid();
dt.Rows.Add(id, "Row3", parentId);
  
this.radGridView1.AutoGenerateColumns = false;
  
GridViewTextBoxColumn textBoxColumn2 = new GridViewTextBoxColumn("Name");
textBoxColumn2.FieldName = "Name";
radGridView1.MasterTemplate.Columns.Add(textBoxColumn2);
  
this.radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
  
this.radGridView1.Relations.AddSelfReference(this.radGridView1.MasterTemplate, "Id", "ParentId");
this.radGridView1.DataSource = dt;

 

 

0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 25 Dec 2018, 06:04 AM
Hello, Dilshod,     

The Relations.AddSelfReference method specifies the fields/columns in RadGridView that define the relation. If the grid doesn't contain such columns, it wouldn't be possible to build the hierarchical structure as it wouldn't be possible to determine the parent/child columns relation. 

We haven't had similar reports from other customers for the content of the help article. However, we will revise it in order to avoid any further confusion.

I hope this information helps. 

Merry Christmas 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
GridView
Asked by
Dilshod
Top achievements
Rank 1
Answers by
Dilshod
Top achievements
Rank 1
Dess | Tech Support Engineer, Principal
Telerik team
Share this question
or