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.

foreign key relation...urgent

Thread ID:

Created:

Updated:

Platform:

Replies:

92410 Jan 13,2010 05:02 AM Jan 18,2010 07:42 AM ASP.NET Web Forms (Classic) 1
loading
Tags: GridGroupingControl
Santosh U
Asked On January 13, 2010 05:02 AM

Hi,

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

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

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

CompanyProduct:
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 07:42 AM

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:

http://help.syncfusion.com/ug_74/gridweb/CreatingTemplates.html


Let me know if you have any queries.

Regards,
Jaffer.B

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.

;