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

foreign key relation...urgent

Thread ID:





92410 Jan 13,2010 10:02 AM UTC Jan 18,2010 12:42 PM UTC ASP.NET Web Forms (Classic) 1
Tags: GridGroupingControl
Santosh U
Asked On January 13, 2010 10:02 AM UTC


I have 3 tables named Company,ComapnyManager,CompanyProduct as follows,

Company Table:
Companyid name address
1 kk add1
2 gg add2
3 hh add3

CompanyId ManagerId Name
1 1 name1
1 2 name1
2 3 name1
3 4 name1

Id empid prodid name
1 1 1 prod1
2 1 2 prod2
3 1 3 Prod3
4 2 1 prod1
5 2 4 prod4

I want to display Company table data in grid grouping control, and its related product information should be displayed in the same table as product combo column, not as child grid.
And Manager information as a child table which i am able to.

But when i am giving foreign key relation between Company and product table,the product column is not been displayed.
when i am giving related master relation between these two tables,product column is getting displayed but as a child grid,which i dont want.

it should be displyed as in same Company table grid with new column as product and for each Company related product information only, in combo cell type.

Please help me..

Jaffersathick B [Syncfusion]
Replied On January 18, 2010 12:42 PM UTC

Hi Santhosh,

Thank you for using Syncfusion products.

We suggest you to add the combo column using the ItemTemplate in QueryCellStyleInfo event add bind with the datasource for the same. So that you will get the Product information in the combo column. While getting the product information pass the companyId in the function and fetch the related records from it.

Please refer the link below for adding ItemTemplate in the QueryCellStyleInfo event:


Let me know if you have any queries.



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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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