[Solved] Self-referencing

[jay]

Hi, I have been trying to get a piece of code I got off your self-referencing demo to work under a slightly different situation.

I am using a database that has (like in the AdventureWorks database) a different table that stores the names of the employees. So I use a view to populate my datagrid to show all the fields I need to see on the grid. My problem is in knowing which rows have direct reports.

I tried using the code below, but each time i get the following error message in the HasSubordinates block:

System.InvalidCastException was unhandled by user code

  Message=Unable to cast object of type 'System.Windows.Controls.DomainDataSourceView' to type 'System.Collections.Generic.IEnumerable`1[SLightBizApp.Web.vw_Employee]'.

        private void RadGridViewEmp_RowLoaded(object sender, Telerik.Windows.Controls.GridView.RowLoadedEventArgs e)

        {

            GridViewRow row = e.Row as GridViewRow;

            vw_Employee employee = e.DataElement as vw_Employee;

            if (row != null && employee != null)

            {

                row.IsExpandable = this.HasSubordinates(employee);

            }            

        }

        private bool HasSubordinates(vw_Employee employee)

        {        

            return

            (from emp in (IEnumerable<vw_Employee>)this.RadGridViewEmp.ItemsSource

             where emp.ReportsToID == employee.EmployeeID

             select emp).Any();

        }

------------------------------------------------------------------------------------

Any pointers?

Thanks

J

[Vlad]

Hi,

 The exception says that you cannot cast DomainDataSourceView (the grid ItemsSource) to IEnumerable<vw_Employee>. You can find more info about DomainDataSourceView here.

Kind regards,
Vlad
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.

[kannan]

Hi,
     You can use table instead of view ....it is working...

 private bool HasSubordinates(tableName employee)

        {        

            return

            (from emp in (IEnumerable<tablename>)this.RadGridViewEmp.ItemsSource

             where emp.ReportsToID == employee.EmployeeID

             select emp).Any();

        }