We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Can GridGroupingControl use the relations from DataSet to autoconvert ID to String names

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?

2 Replies

AD Administrator 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.

AN Andrew July 15, 2005 12:13 PM UTC

Thanks! We have no multiple relations in our case, but I see, you are right.

Live Chat Icon For mobile
Up arrow icon