This constraint cannot be enabled as not all values have corresponding parent values.

[jo]

This is my data on datasource-

COMPANYID	CATEGORYID	COMPANYNAME	CATEGORYNAME
687d6bf7	103b9297	a123	abc
687d6bf7	6903d527	a123	xyz

This is my code-

<

 

telerik:RadTreeView ID="RadTreeView1" runat="server" DataSourceID="ObjectDataSourceCompany"

 

 

DataTextField="COMPANYNAME" DataFieldID="CATEGORYID" DataFieldParentID="COMPANYID"

 

 

DataValueField="CATEGORYID">

 

 

</telerik:RadTreeView>

This is the Error-

 

This constraint cannot be enabled as not all values have corresponding parent values.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: This constraint cannot be enabled as not all values have corresponding parent values.

Did I miss anything...How do i fix this??

[Princy]

Hello Jo,

The ParentID of the root items should be null. If for some reason the data source comes without null values for the ParentID column, the solution is to create a query that returns the expected value (null). Check out the code below which shows how to convert ParentID= 0 to ParentID=null
SELECT ID, Text, IF(ParentID = 0, NULL, ParentID) FROM table

You may also go throught he following links which refers to the above mentioned:
Treeview Problem

-Princy.

[JohnRah]

Or you can use:

SELECT
    ID, Text,
    CASE WHEN ParentID=0
        THEN NULL
         ELSE ParentID
    FROM table

[Sachita]

  private static void CreateDataRelations(ref DataSet ds, bool createConstraints)
        {

            DataRelation dataRelation = new DataRelation("PublicationTypeChildren",
                ds.Tables[0].Columns[(int)PublicationTypeColumns.Guid],
                ds.Tables[1].Columns[(int)PublicationTypeChildrenColumns.ParentGuid],
                createConstraints);
            ds.Relations.Add(dataRelation);
            
        }

As I have tried Solutions of Many Posts but didnot get any Luck,Can you please help.

[Peter Milchev]

Hello Sachita,

As the error message says, the data has entries that have a non-existent parent node. To debug that, I would recommend to:

1) Get all ParentIDs of all entries

2) Check if each of the ParentIDs have a corresponding item with ID equal to the ParentID

Once you do that, you should find which entries have non-existent parents and fix them.

Regards,
Peter Milchev
Progress Telerik