Thank You, Alan, for your prompt reply!

I now able to implement what I need.

Thanks a lot!!!

n Thanks for your reply Alan,

There are two data tables

Table 1

EmployeeID, Employee Name, Employee Address

Table 2

EmployeeID, Employee Department

I have implemented relationship on Table1 > EmployeeID with Table 2 EmployeeID

The scenario is it might be possible that Table 2 do not have all the employee data by employee id. Let's say

Table 1 Data:

Employee ID     Employee Name          Employee Address

Emp1                Employee Name 1       Address 1

Emp2                Employee Name 2       Address 2

Emp3                Employee Name 3       Address 3

Emp4                Employee Name 4       Address 4

Table 2 Data:

EmployeeID   Employee Department

Emp1             Department A1

Emp1             Department A2

Emp1             Department A3

Emp3             Department A1

Emp3             Department B1

What I want to display in hierarchical gridview is, all the Table 1 rows and child row. In case of no child row for parent row, the "+" sign should not be visible to the user.

Let me know if you need anything else from my side.

Thanks!