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.
In the FAQ on this site, the procedures for building a triple layer relationship between grids is detailed. I''m building something that deperately needs this functionality, but I cant seem to make it work.
First, the tables are the exact tables from the Northwind database. (Categories, Products, Suppliers)
I''ve got these tables in a Dataset in memory, and I have added relationships as follows:
MyDS.Relations.Add("ProductsToCategories",MyDS.Tables["Categories"].Columns["CategoryID"],MyDS.Tables["Products"].Columns["CategoryID"]);
MyDS.Add("ProductsToSuppliers",MyDS.Tables["Suppliers"].Columns["SupplierID"],MyDS.Tables["Products"].Columns["SupplierID"]);
Here is how I bind the grids:
CategoryGrid.DataSource = gate.ShogunDataSet.Tables["ProductCategories"];
this.CategoryGrid.AllowNavigation=false;
mf.SetProgressValue(80);
MyDS.DataSource = MyDS.Tables["ProductCategories"];
this.ProductGrid.DataMember = "ProductsToCategories";
this.ProductGrid.AllowNavigation=false;
mf.SetProgressValue(90);
this.SuppliersGrid.DataSource = gate.ShogunDataSet.Tables["ProductCategories"];
this.SuppliersGrid.DataMember = "ProductsToCategories.ProductToSuppliers";
this.SuppliersGrid.AllowNavigation=false;
Sorry, I sent that last message before I could finish stripping out irrelevent code and replacing the object names ,shogundataset, with MyDS. Also, the table name "ProductCategories" is actually "Categories". Is that too confusing? I apologize for making it so complicating! Thanks in advance for any input!
