I am trying to use a GridDropDownColumn in a detail table, while using a DataSet as the source for the grid. I have a typed DataSet with one table for the MasterTableView, one table for the DetailTableView, and one table that should populate the drop-down list when editing a row in the DetailTableView. By the Telerik documentation, I need to set the DataSource for the DetailTableView during the DetailTableDataBind event (as laid out here:
http://www.telerik.com/help/aspnet-ajax/grid-hierarchical-data-binding-using-detailtabledatabind.html ).
The DetailTableView displays correctly. However, when I try to edit the DetailTableView, I get a DataBinding error because now the DataSource for the GridDropDownColumn is the collection of rows set up by the instructions for "Binding detail tables using DataTable.Select" or "Binding detail tables using a filtered DataView". In either case, the GridDropDownColumn does not look to the parent DataSet, but to that specific collection.
Example: Table A has the columns 'MasterID' and 'Name'. Table B has the columns 'MasterID' 'OrderID' and 'Salesman'. Table C has the columns 'ItemID' and 'ItemName'. Table A is the table for the MasterTableView. Table B is the table for the DetailTableView, using DataTable.Select to return the rows from table B that are relevant. I want to make a drop-down list that will let me join 'OrderID' in the DetailTableView to the 'ItemID' column in table C, allowing me to select anything from table C to set the 'OrderID' value in table B. How can I do this?
http://www.telerik.com/help/aspnet-ajax/grid-hierarchical-data-binding-using-detailtabledatabind.html ).
The DetailTableView displays correctly. However, when I try to edit the DetailTableView, I get a DataBinding error because now the DataSource for the GridDropDownColumn is the collection of rows set up by the instructions for "Binding detail tables using DataTable.Select" or "Binding detail tables using a filtered DataView". In either case, the GridDropDownColumn does not look to the parent DataSet, but to that specific collection.
Example: Table A has the columns 'MasterID' and 'Name'. Table B has the columns 'MasterID' 'OrderID' and 'Salesman'. Table C has the columns 'ItemID' and 'ItemName'. Table A is the table for the MasterTableView. Table B is the table for the DetailTableView, using DataTable.Select to return the rows from table B that are relevant. I want to make a drop-down list that will let me join 'OrderID' in the DetailTableView to the 'ItemID' column in table C, allowing me to select anything from table C to set the 'OrderID' value in table B. How can I do this?