Questions on UI for ASP.NET AJAX Forum

4 answers

665 views

TreeView Bind Error:"This constraint cannot be enabled as not all values have corresponding parent values."

Hi everyone.
I've a problem with my TreeView controls. the problem is;

When I try to bind data from DB to RadTreeView, it gives this error : "This constraint cannot be enabled as not all values have corresponding parent values."

C# Code :

    
            private void ForTree()
        
            {
        
            line 1:String Query = "SELECT * FROM dbo.FESTIVAL WHERE flag=0";
        
            line 2:myDataTable3 = dtClass.GetQuery(Query);
        
                    RadTreeView3.DataSource = myDataTable3;
        
                    RadTreeView3.DataFieldID = "fest_id";
        
                    RadTreeView3.DataValueField = "fest_id";
        
                    RadTreeView3.DataFieldParentID = "cat_id";
        
                    RadTreeView3.DataTextField = "title";
        
            line 8:RadTreeView3.DataBind();&nbsp;&nbsp; // This is the line where error occurs. 

            }

line 2 is connects to DB and fill the datatable from another class.

when I write the query :"SELECT * FROM dbo.FESTIVAL", there was no problem but when I add it "WHERE flag=0" clause to filter some data at "line 1" it gives me error. And interesting point is When I change the Flag value to "1" (flag=1) it works fine !!, it makes me crazy.

I search all the topics in "Telerik Forums" and there were some problems as mine, but my table is not spereated and all the Parent_id's values are "NULL"

so what can I do at this situation?

Database DataTable:

cat_id is a child_id. title column has some words will placed on node.

dbo.Festival
Fest_id   Cat_id flag title
1   NULL      0
2   NULL      1
3    NULL      0
4   NULL      1
5   NULL 0
6             NULL 1
7   NULL      0
8   NULL      1
9 NULL      0
10 NULL   1
11    NULL   0
12   NULL    1
13    NULL   0
14    NULL    1
15    NULL    0
16 NULL    1
17           NULL    0
18           NULL     1
19    NULL   0
20    NULL     1
21   1          0
22           1 1
23           1      0
24           1 1
25   2      0
26   2    1
27    2   0
28    2         1
29    3    0
30    3    1
31    4      0
32   4      1
33           7      0
34   7      1
35            8   0
36      8   1
37            9      0
38            9          1
39          10 0

...it goes until 180 records.

TreeView

answered on 14 Mar 2015

1 answer

79 views

Unwanted column text added after sort

The grid looks fine and when I sort a column the class name of my Serializable class gets added many time to the right. Every time I press sort more text gets added. I have attached picture.

I am trying to add columns names at runtime since I do not know them in advanced. My code is based on the Grid - Virtualization example and the documentation on columns Creating a Hierarchical Grid Programmatically. It basically right out of the example and documentation.

My Asp:

<%@ Page Title="Group Administration" Language="C#" MasterPageFile="~/Organization.Master" AutoEventWireup="true" CodeBehind="GroupAdmin.aspx.cs" Inherits="SignupList.Admin.GroupAdmin" %>

<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">

Administration

<telerik:RadAjaxLoadingPanel runat="server" ID="RadAjaxLoadingPanel"></telerik:RadAjaxLoadingPanel>

<telerik:RadAjaxPanel runat="server" ID="RadAjaxPanel" LoadingPanelID="RadAjaxLoadingPanel" CssClass="demo-container">

<telerik:RadGrid ID="AdminGrid" OnNeedDataSource="AdminGrid_NeedDataSource" runat="server"

Skin="Default" AutoGenerateColumns="false" AllowSorting="true" GroupingEnabled="false"

EnableHeaderContextMenu="true" AllowPaging="true" PageSize="50">

<ClientSettings ReorderColumnsOnClient="true" AllowColumnsReorder="true" ColumnsReorderMethod="Reorder">

<Virtualization EnableVirtualization="true" InitiallyCachedItemsCount="2000"

LoadingPanelID="RadAjaxLoadingPanel" ItemsPerView="100"/>

<Scrolling AllowScroll="true" UseStaticHeaders="true" ScrollHeight="500px" />

<Resizing AllowColumnResize="true" />

</ClientSettings>

<PagerStyle Mode="NextPrevNumericAndAdvanced"></PagerStyle>

</telerik:RadGrid>

</telerik:RadAjaxPanel>

</asp:Content>

My aspx.cs file

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web.UI.WebControls;

using SignupList.Com.SignupList;

using SignupList.Com.SignupList.Display.Models;

using Telerik.Web.UI;

namespace SignupList.Admin

{

public partial class GroupAdmin : System.Web.UI.Page

{

protected void Page_Init(object source, System.EventArgs e)

{

DefineGridStructure(AdminGrid);

}

protected void Page_Load(object sender, EventArgs e) {

}

private static readonly Random Random = new Random();

static string[] contactNames = new string[] { "Antonio Moreno", "Elizabeth Lincoln", "Hanna Moos", "Jaime Yorres", "Georg Pipps",

"Pascale Cartrain", "Paul Henriot", "Matti Karttunen", "Patricio Simpson","Howard Snyder"};

static string[] companyNames = new string[] { "Blauer See Delikatessen", "Folies gourmandes", "Hungry Coyote Import Store", "Let's Stop N Shop",

"B's Beverages", "QUICK-Stop", "Split Rail Beer & Ale", "Wartian Herkku","Sant� Gourmet","Romero y tomillo" };

static string[] contactTitles = new string[] { "Marketing Assistant", "Sales Associate", "Sales Agent", "Sales Representative",

"Owner", "Sales Manager", "Accounting Manager","Marketing Manager","Sales Consultant","Accountant"};

static string[] countries = new string[] { "Bulgaria", "USA", "Austria", "Germany", "Italy", "England", "Argentina", "Brazil", "France", "Spain" };

static string[] ratings = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "10" };

public List<Member> DataSource

{

get

{

object obj = Application["GroupAdminDataSource"];

if (obj == null) {

List<Member> customers = new List<Member>();

for (int i = 0; i < 2000; i++)

{

int titlesIndex = Random.Next() % 10;

int companyIndex = Random.Next() % 10;

int contactIndex = Random.Next() % 10;

int ratingIndex = Random.Next() % 10;

int countryIndex = Random.Next() % 10;

Member customer = new Member();

customer.ID = (i + 1).ToString();

;

customer.Value1 = contactTitles[titlesIndex];

customer.Value2 = companyNames[companyIndex];

customer.Value3 = contactNames[contactIndex];

customer.Value4 = countries[countryIndex];

customer.Value5 = ratings[ratingIndex];

customers.Add(customer);

}

Application["GroupAdminDataSource"] = customers;

}

return (List<Member>)Application["GroupAdminDataSource"];

}

set

{

Application["GroupAdminDataSource"] = value;

}

protected void AdminGrid_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

AdminGrid.DataSource = DataSource;

}

[Serializable]

public class Member

{

public string ID { get; set; }

public string Value1 { get; set; }

public string Value2 { get; set; }

public string Value3 { get; set; }

public string Value4 { get; set; }

public string Value5 { get; set; }

}

private void DefineGridStructure(RadGrid adminGrid)

{

if (adminGrid.MasterTableView.Columns.Count > 1) {

// exit if columns are already defined

return;

}

adminGrid.MasterTableView.DataKeyNames = new string[] { "ID", "Value1", "Value2","Value3", "Value4", "Value5" };

//Add columns

GridBoundColumn boundColumn;

boundColumn = new GridBoundColumn();

boundColumn.UniqueName = "ID";

boundColumn.DataField = "ID";

boundColumn.HeaderText = "ID";

boundColumn.HeaderStyle.Width = Unit.Pixel(50);