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]GOALTER TABLE [dbo].[T1] WITH CHECK ADD CONSTRAINT [FK_T1_T1] FOREIGN KEY([parentid])REFERENCES [dbo].[T1] ([id])GOALTER TABLE [dbo].[T1] CHECK CONSTRAINT [FK_T1_T1]