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.
Unfortunately, activation email could not send to your email. Please try again.

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

Thread ID:

Created:

Updated:

Platform:

Replies:

31836 Jul 15,2005 06:38 AM Jul 15,2005 08:13 AM Windows Forms 2
loading
Tags: GridControl
Andrew
Asked On July 15, 2005 06:38 AM

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 06:56 AM

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 08:13 AM

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.

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.

;