The Syncfusion® native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
I have a dataset with two tables. Say Customers and Orders. I display the Orders table in the grid, but want a drop down combo for the CustomerID column. Also, I want to display and sort by Customer name from the Customer table. What is the best way to do this. Can it be done both by code and the designer? Thanks.
ADAdministrator Syncfusion Team April 6, 2005 10:44 AM UTC
Take a look at the \Syncfusion\Essential Suite\3.0.1.0\Windows\Grid.Windows\Samples\Grouping\ForeignKeyReference. It does things from code, but I think you should be able to set the same properties via the designer as well.
ADAdministrator Syncfusion Team April 6, 2005 02:25 PM UTC
I followed the example you suggested, but have one problem: The grid shows all columns from the foreign key table in the main grid. Following the example, I added the line
customersRd.ChildTableDescriptor.VisibleColumns.Add("CompanyName");
This restricted the columns shown in the drop down grid, but still all columns from the foreign key table was shown in the main grid. How can I restrict the columns shown in the main grid?
ADAdministrator Syncfusion Team April 6, 2005 02:33 PM UTC
Did you try explicitly removing them from the parent''s VisibleColumns (customers.TableDescriptor.VisibleColumns.Remove).
ADAdministrator Syncfusion Team April 7, 2005 08:04 AM UTC
Removing the columns explicitly from the main table worked fine. Now I can have only one column from the Customer table in the main grid and many columns in the drop down grid. Perfect!