When I use the tree as MultiColumnComboBox
The table has a relation with itself
When I click on MultiColumnComboBox the popup
The following error occurs
sql create table
relation in id and parentid
The table has a relation with itself
When I click on MultiColumnComboBox the popup
The following error occurs
radMultiColumnComboBox1.MultiColumnComboBoxElement.EditorControl.Relations.AddSelfReference(
this
.radMultiColumnComboBox1.MultiColumnComboBoxElement.EditorControl.MasterTemplate,
"id"
,
"parentid"
);
sqlDataAdapter1.Fill(dataSet11);
radMultiColumnComboBox1.DataSource = t1BindingSource;
radMultiColumnComboBox1.DisplayMember =
"name"
;
radMultiColumnComboBox1.ValueMember =
"id"
;
this
.radMultiColumnComboBox1.AutoFilter =
true
;
this
.radMultiColumnComboBox1.DisplayMember =
"name"
;
FilterDescriptor filter =
new
FilterDescriptor();
filter.PropertyName =
this
.radMultiColumnComboBox1.DisplayMember;
filter.Operator = FilterOperator.Contains;
this
.radMultiColumnComboBox1.EditorControl.MasterTemplate.FilterDescriptors.Add(filter);
relation in id and parentid
CREATE
TABLE
[dbo].[T1](
[id] [
int
]
NOT
NULL
,
[
name
] [nvarchar](50)
COLLATE
Arabic_CI_AS
NULL
,
[parentid] [
int
]
NULL
,
CONSTRAINT
[PK_T1]
PRIMARY
KEY
CLUSTERED
(
[id]
ASC
)
WITH
(PAD_INDEX =
OFF
, STATISTICS_NORECOMPUTE =
OFF
, IGNORE_DUP_KEY =
OFF
, ALLOW_ROW_LOCKS =
ON
, ALLOW_PAGE_LOCKS =
ON
)
ON
[
PRIMARY
]
)
ON
[
PRIMARY
]
GO
ALTER
TABLE
[dbo].[T1]
WITH
CHECK
ADD
CONSTRAINT
[FK_T1_T1]
FOREIGN
KEY
([parentid])
REFERENCES
[dbo].[T1] ([id])
GO
ALTER
TABLE
[dbo].[T1]
CHECK
CONSTRAINT
[FK_T1_T1]