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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

Thread ID:

Created:

Updated:

Platform:

Replies:

31836 Jul 15,2005 10:38 AM UTC Jul 15,2005 12:13 PM UTC WinForms 2
loading
Tags: GridControl
Andrew
Asked On July 15, 2005 10:38 AM UTC

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?

Administrator [Syncfusion]
Replied On 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.

Andrew
Replied On July 15, 2005 12:13 PM UTC

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

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;