Hello,
I am currently using Prometheus RadGrid with a two level hierarchy. The select statement appears to work beautifully, however, upon insert I would like to be able to use GridBoundDropDownColumns or RadComboBoxes in a way that allows me to update the detail tables GridBoundDropDownColumns or RadComboBoxes. I would like to use these controls for filtering through the <detailtable> Gridview data. My rational for this can be understood by the following example: I have the high level category Product Type and underneath Product Type there are many products. Currently some Products have a Product Type ID which serves as Key for the detail table. I have an existing inventory of all the products that I want to select from for an insert into my Product Type. Upon inserting or adding a new record I would like to choose from the my existing inventory. So really I am looking to create an association for the insert, not insert a totally new product. This would mean an insert into my level one hierarchy table a new record, that associates the specific product with the productType. Thanks for your time.
Best, Andrew
I am currently using Prometheus RadGrid with a two level hierarchy. The select statement appears to work beautifully, however, upon insert I would like to be able to use GridBoundDropDownColumns or RadComboBoxes in a way that allows me to update the detail tables GridBoundDropDownColumns or RadComboBoxes. I would like to use these controls for filtering through the <detailtable> Gridview data. My rational for this can be understood by the following example: I have the high level category Product Type and underneath Product Type there are many products. Currently some Products have a Product Type ID which serves as Key for the detail table. I have an existing inventory of all the products that I want to select from for an insert into my Product Type. Upon inserting or adding a new record I would like to choose from the my existing inventory. So really I am looking to create an association for the insert, not insert a totally new product. This would mean an insert into my level one hierarchy table a new record, that associates the specific product with the productType. Thanks for your time.
Best, Andrew
1 Answer, 1 is accepted
0
Bodevain Svensson
Top achievements
Rank 1
Rank 1
answered on 04 Apr 2008, 07:47 AM
Andrew, let me share my opinion on this subject providing that I use RadGrid from some time now.
First, ensure whether you configured properly your GridDropDownColumns - I find this article a good starting point.
Second, to set the relation between newly inserted items in a child table and its parent item, you have to set the key field pointing to the parent foreign key manually. An example that I found:
http://www.telerik.com/community/code-library/submission/b311D-ghdhk.aspx
Finally, if you want to implement related dropdown editors at the same level of editing, take a look at this RadGrid online demo.
Hope these directions help.
Bodevain
First, ensure whether you configured properly your GridDropDownColumns - I find this article a good starting point.
Second, to set the relation between newly inserted items in a child table and its parent item, you have to set the key field pointing to the parent foreign key manually. An example that I found:
http://www.telerik.com/community/code-library/submission/b311D-ghdhk.aspx
Finally, if you want to implement related dropdown editors at the same level of editing, take a look at this RadGrid online demo.
Hope these directions help.
Bodevain