How to display Data from database to Radtreeview

Hi Dess

Thanks for your kind help i dont want to export treeview to excel. But I want to show data in treeview like parent first then child, then their child nodes like that. I have highlight with yellow color. i can explain you MainLot is 22010001 their sub lot is 22010005 child of 22010005- 22010026

Thanks & Regards

Nandan Navale

Hello, Nandan,   

I am really sorry for the misunderstanding. It was caused by the picture from Excel and assuming that you need a report.

The illustrated data seems to represent self-referencing hierarchy which is supported by RadTreeView:
https://docs.telerik.com/devtools/winforms/controls/treeview/data-binding/binding-to-self-referencing-data

I have prepared a sample code snippet for your reference: 

            DataTable dt = new DataTable();
            dt.Columns.Add("Fr_Lot_No", typeof(string));
            dt.Columns.Add("To_Lot_No", typeof(string)); 
            dt.Rows.Add("22010001", "22010005");
            dt.Rows.Add("22010001", "22010008");
            dt.Rows.Add("22010001", "22010009");
            dt.Rows.Add("22010002", "22010010");
            dt.Rows.Add("22010009", "22010025");
            dt.Rows.Add("22010005", "22010026");
            dt.Rows.Add(null, "22010001");

            this.radTreeView1.DisplayMember = "To_Lot_No";
            this.radTreeView1.ParentMember = "Fr_Lot_No";
            this.radTreeView1.ChildMember = "To_Lot_No";
            this.radTreeView1.DataSource = dt;

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

Hi Dess

Thanks again for your help because of you I am able to resolve complex issue with telerik controls.

Again Thank you

Regards

Nandan Navale