Click here to Skip to main content
15,896,207 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
i want to find binary level .i am providing details below(all level in data grid).i have a binary tree their first node id is 0013337 .this node contain 256 sub nod .i want to find label of tree. as like


Welcome SOMNATH GHOSH [0013337]
1st Level
Total No. of Joining : 2
Name	ID No.	Join Date	Introducer ID	Power 2 Complete
MAYA DAS
0017244	08/05/2010	0013337	15/05/2010
SMRITI JATI
0017246	08/05/2010	0013337	15/05/2010

2nd Level 
Total No. of Joining : 4
Name	ID No.	Join Date	Introducer ID	Power 2 Complete
AKHTAR ABBAS
0015962	15/05/2010	0017244	30/05/2010
PRANAB KUMAR GHORAI
0016013	04/09/2010	0017246	18/09/2010
SAMAR DOLUI
0015961	16/08/2010	0017246	24/08/2010
SIMA SARKAR
0015959	04/09/2010	0017244	04/09/2010

3rd Level 
Total No. of Joining : 8
Name	ID No.	Join Date	Introducer ID	Power 2 Complete
ABHIJIT SARKAR
0039679	04/09/2010	0015959	18/09/2010
ABHISEK DAS
0040888	18/09/2010	0016013	30/09/2010
NAZIA PARVEEN
0030143	30/05/2010	0015962	14/06/2010
PRAYAGRAJ MANDAL
0040887	18/09/2010	0016013	30/09/2010
PROVAS DOLUI
0037069	24/08/2010	0015961	10/02/2011
RABIA BEGUM
0030139	30/05/2010	0015962	14/06/2010
SHILA ADHIKARY
0039678	30/10/2010	0015959	31/10/2010
SONALI SAHA(DOLUI)
0037068	24/08/2010	0015961	10/02/2011

4th Level 
Total No. of Joining : 16
Name	ID No.	Join Date	Introducer ID	Power 2 Complete
ALOKE DHARA
0045717	31/10/2010	0039678	31/10/2010
AMIT DEY
0061517	10/02/2011	0037068	11/02/2011
ARUN DEY
0062108	10/02/2011	0037068	 
ASIM DEY
0061516	10/02/2011	0037069	10/02/2011
IMTYAZ AHMED
0030746	14/06/2010	0030139	 
JHUMA SARKAR
0041904	03/12/2010	0039679	16/12/2010
KAVITA ROY
0030748	17/09/2010	0030139	 
KINKAR KUMAR GHORAI
0043125	08/11/2010	0040887	08/11/2010
LATIKA BERA
0043388	02/10/2010	0040888	13/10/2010
MRINMOY GHORAI
0043124	11/02/2011	0040887	12/02/2011
PANCHANAN DAS
0043123	30/09/2010	0040888	13/10/2010
PRIYA DAS
0045724	31/10/2010	0039678	31/10/2010
RAJARSHI CHAKRABORTY
0062109	10/02/2011	0037069	10/02/2011
RANJEET KUMAR SINGH
0041905	03/12/2010	0039679	17/12/2010
ROUSAN ARA
0030305	11/06/2010	0030143	 
ROUSHAN ARA
0030747	14/06/2010	0030143	29/06/2010

5th Level 
Total No. of Joining : 26
Name	ID No.	Join Date	Introducer ID	Power 2 Complete
AMITA JATI
0062104	10/02/2011	0061516	 
ANIMA PAL
0059383	11/02/2011	0061517	12/02/2011
ARUNA DEY
0063011	12/02/2011	0062108	 
BISWAJIT MAITI
0044445	08/11/2010	0043388	08/11/2010
CHAITALI MISHRA
0060963	10/02/2011	0062109	 
CHANDESHWAR RAY
0060881	10/02/2011	0061517	 
CHINMOY GHORAI
0047909	08/11/2010	0043125	 
DHRITIMAN BANERJEE
0060959	10/02/2011	0062109	 
GHANTASWAR NASKAR
0060880	10/02/2011	0061516	 
GULSHAN ARA
0031787	29/06/2010	0030747	 
KRISHNA ADHIKARY
0052291	17/12/2010	0041905	31/12/2010
KRISHNA ADHIKARY
0047000	31/10/2010	0045724	 
KRISHNA DEY
0052287	16/12/2010	0041904	 
MALATI MONDAL
0052285	16/12/2010	0041904	30/12/2010
MINA DAS
0052637	17/12/2010	0041905	 
PAPIA MANNA
0047910	08/11/2010	0043125	 
PARNA DAS
0045729	31/10/2010	0045717	 
PRASENJIT MANNA
0044444	08/11/2010	0043388	08/11/2010
PRASUN MAITI
0044443	11/10/2010	0043123	 
SHAHEEN PARVEEN
0052057	14/12/2010	0030305	14/12/2010
SUBHASIS MONDAL
0045731	31/10/2010	0045717	14/11/2010
SUCHISMITA SHAW
0045736	31/10/2010	0045724	 
TABEJ ALAM ANSARI
0031788	29/06/2010	0030747	 
TANMOY KUMAR TRIPATHY
0044446	08/11/2010	0043123	08/11/2010
TAPAN GHORAI
0059382	12/02/2011	0043124	 
TRIPTI GHORAI
0059381	12/02/2011	0043124	 

6th Level 
Total No. of Joining : 17
Name	ID No.	Join Date	Introducer ID	Power 2 Complete
ANJU BAG
0053564	31/12/2010	0052291	 
ANNA DAS
0059384	11/02/2011	0059383	 
ARUN HALDER
0046998	14/11/2010	0045731	28/11/2010
CHAMPA KHARA
0055741	30/12/2010	0052285	13/01/2011
DEBASISH DAS
0047914	08/11/2010	0044444	 
KALI DAS
0055734	30/12/2010	0052285	 
MALLIKA BERA
0047906	08/11/2010	0044446	08/11/2010
MD JAVED
0052059	14/12/2010	0052057	 
MD NIZAM UDDIN
0052056	14/12/2010	0052057	14/12/2010
NANTU KAYAL
0047903	14/11/2010	0045731	28/11/2010
PALLABI MANNA
0047915	08/11/2010	0044444	 
SARBANI DAS
0047913	08/11/2010	0044445	 
SUMIT BHUNIA
0047908	08/11/2010	0044446	08/11/2010
SUMOTI NASKAR
0062103	12/02/2011	0059383	 
SUPRAVAT BERA
0044447	21/10/2010	0044443	 
SURYASHISH SANYAL
0047912	08/11/2010	0044445	 
TAPASI SADHUKHAN
0053563	31/12/2010	0052291	 

7th Level 
Total No. of Joining : 12
Name	ID No.	Join Date	Introducer ID	Power 2 Complete
ALOK DAS
0055740	13/01/2011	0055741	 
ANJALI BERA
0047985	08/11/2010	0047906	 
ASOK DAS
0053562	13/01/2011	0055741	 
BIMALA BERA
0047986	08/11/2010	0047906	 
CHITTA RANJAN DAS
0050400	28/11/2010	0047903	11/12/2010
MANOWARA SULTANA
0052055	14/12/2010	0052056	 
MOUSUMI BANERJEE
0050401	28/11/2010	0046998	11/12/2010
PRANABES GHORAI
0047907	08/11/2010	0047908	 
RUPALI KAYAL
0050165	28/11/2010	0047903	 
SHAFIA MOIN
0052058	14/12/2010	0052056	14/12/2010
SUBHAS CHANDRA GHORAI
0047911	08/11/2010	0047908	 
TUSHAR BARAN JATI
0050402	28/11/2010	0046998	11/12/2010

8th Level 
Total No. of Joining : 8
Name	ID No.	Join Date	Introducer ID	Power 2 Complete
AMULYA RATAN DAS
0051791	11/12/2010	0050400	 
ASHOK JANA
0051792	11/12/2010	0050401	 
BIKASH DHARA
0051819	11/12/2010	0050402	 
CHAND OSMAN
0052060	14/12/2010	0052058	 
KALI TARA DAS
0051790	11/12/2010	0050400	 
MD NAYAZ
0052061	14/12/2010	0052058	 
SANJIB SARKAR
0051820	11/12/2010	0050401	 
TAPAN ADHIKARY
0051118	11/12/2010	0050402
Posted
Updated 8-Nov-11 0:55am
v2
Comments
Richard MacCutchan 8-Nov-11 7:15am    
Your question is still not clear, the data above means nothing without some structure information as to what fields exist at each level.
Yvan Rodrigues 8-Nov-11 12:00pm    
You question does not make a lot of sense in English. Try asking it a different way with more details about what you are trying to accomplish, and what problem you are encountering.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900