This question is locked. New answers and comments are not allowed.
Hi,
I'm trying to display a list of categories in a treeview form inside a RadComboBox. I can do that either with TreeView or RadGrid. I want the ability to filter as well as we type in the RadComboBox.
I am using OpenAccess ORM with 3 Layers.
1. BL (Contains the objectscope provider)
2. BO (Persistent Classes)
3. UI (WEB)
I dont want to use the openaccessdatasource control. I want to populate the treeview from the IQueryResult (or BindingResult.. etc)
My table contains the following fields:
Name,
CategoryID,
ParentCategoryID,
Description,
Notes
Since this table is Self referencing, I am not able to get the ParentCategoryID as a field, but instead as Category Object.
I am not able to bind the treeview as it requires a ParentCategoryID and I get the Category object instead of the field value.
Is it possible to execute a simple SQL query using ORM to return a datatable etc?
Also, How do I implement the search feature in treeview combobox or grid combobox.
I'm trying to display a list of categories in a treeview form inside a RadComboBox. I can do that either with TreeView or RadGrid. I want the ability to filter as well as we type in the RadComboBox.
I am using OpenAccess ORM with 3 Layers.
1. BL (Contains the objectscope provider)
2. BO (Persistent Classes)
3. UI (WEB)
I dont want to use the openaccessdatasource control. I want to populate the treeview from the IQueryResult (or BindingResult.. etc)
My table contains the following fields:
Name,
CategoryID,
ParentCategoryID,
Description,
Notes
Since this table is Self referencing, I am not able to get the ParentCategoryID as a field, but instead as Category Object.
I am not able to bind the treeview as it requires a ParentCategoryID and I get the Category object instead of the field value.
Is it possible to execute a simple SQL query using ORM to return a datatable etc?
Also, How do I implement the search feature in treeview combobox or grid combobox.