Home / Community & Support / Developer Productivity Tools Forums / ASP.NET > Panelbar > RadPanelBar MS SQL Databinding

• Lourein

  Posted on Jun 17, 2007 (permalink)

  I have followed the instructions as per manual. My data extracted from SQL server look as follows:
  Parent   Text                                                               Parent
  1        The World Wide Web - 3 months subscription         NULL
  4        Windows Vista - 3 months subscription                  NULL
  2        Word 2007- 3 month subscription                          NULL
  3        Publisher 2007 - 3 month subscription                    NULL
  10      MYOB - For the Accountant                                    4
  7        Word 1.1                                                             1
  8        Marc Test                                                            2
  9        Marc Test                                                            3
  6        Marc Test                                                            1
  
  I am not clear AT ALL why I am getting the following message when trying to bind it:
  "This constraint cannot be enabled as not all values have corresponding parent values." 
  
  I can only assume that it must be the parent value of NULL, but the instruction manual says that, that is in order.
  
  PLEASE HELP!!!?
  

• Poul Henningsen Master

  Posted on Jun 18, 2007 (permalink)

  hi Lourein,
  I suggest you take a look at the following help article that might help you find the error on your side:
  

  • Overview and types of data sources
  • SqlDataSource or AccessDataSource
  • SQL database and SqlDataAdapter

  In addition, have in mind that the table cell of parent id is empty in case an item has no parent, but in SQL Server database you need to set that to NULL.
  
  Cheers, Poul

• Jason

  Posted on Jun 18, 2007 (permalink)

  I have read all the items as pointed out and am still unclear as to why it is doing this. I have followed exactly what they say.
  You will see from my attached sample that the ParentID of the root items are set to NULL:
  Parent   Text                                                               Parent
  1        The World Wide Web - 3 months subscription         NULL
  4        Windows Vista - 3 months subscription                  NULL
  2        Word 2007- 3 month subscription                          NULL
  3        Publisher 2007 - 3 month subscription                    NULL
  10      MYOB - For the Accountant                                    4
  7        Word 1.1                                                             1
  8        Marc Test                                                            2
  9        Marc Test                                                            3
  6        Marc Test                                                            1
  
  and it is still giving me the same error.
  Could it be that the ID and the Parent is of type Integer? Or should I be adding an item with an ID of null as well as a parent of null?

• Paul Paul

  Posted on Jun 19, 2007 (permalink)

  Hi Lourein,
  
  Unfortunately, the provided information doesn't help us much in reproducing the error. It will be best if you can open a support ticket and send us a simple running project (incl. CSS, images, DB backup and so on) demonstrating the problems. In that way we can reproduce and pinpoint the problems you're facing on our side, understand the logic of your application and provide a solution.
  
  Greetings,
  Nick
  the Telerik team

  
  Instantly find answers to your questions at the new Telerik Support Center

• Yousri Elwi Fouad

  Posted on Jul 1, 2007 (permalink)

  hi.. i face exactly the same problem. and i've posted a support ticket but no reply till now.. hope you can help me.
  thnx

• skeptic

  Posted on Mar 1, 2011 (permalink)

  I had the similar issue, but after I change the parentID all to null, it works, just everything went to the root level. which means the problem has nothing to do with the database, somehow, the parentID of the table doesn't work well with the setting of your aspx or aspx.cs that result in the problem. I want to define the root levels from the client-side and assign them the parent value, while in the server side, bind the data source to different root levels based on the parent ID, or if I could just define the root levels in client side and bind different DataSource to different root level items it would be fine. Still working on it now 

Back to Top

Home / Community & Support / Developer Productivity Tools Forums / ASP.NET > Panelbar > RadPanelBar MS SQL Databinding