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.
We have a problem similiar to http://syncfusion.com/Support/forums/message.aspx?MessageID=29631
How can we do the grid automatically import relations (foreign key lookup) specified in DataSet to display the values from the lookup table instead of foregn key?
ADAdministrator Syncfusion Team July 15, 2005 10:56 AM UTC
What happens if you have 18 different relations based on one key column? What relation does the gridgrouping grid use?
Say you have a foriegn DataTable with ID, CompanyName, CompanyPresident, and a main DataTable that has an ID column. Your DataSet has 2 releation IDtoCompanyName and IDtoCompanyPresident. Which relation do you use in the Maintable for the ID column? It is the RelationKind.ForeignKeyReferences that you have to create that picks this out.
You could write a little method that loops through all the relations in your dataset and set up the appropriate RelationKind.ForeignKeyReferences objects, but you will have to decide on how you want to identify which relation you want to use when you have multiple relations based on the same key.
ANAndrewJuly 15, 2005 12:13 PM UTC
Thanks! We have no multiple relations in our case, but I see, you are right.