Class GridForeignKeyHelper

A helper class to set up foreign key relation. It displays a column named DisplayCol in the foreign table where a column named LookUpCol is located in the main table. LookUpCol holds keys values that match the values in a column named idCol in the foreign table.

Inheritance

System.Object

GridForeignKeyHelper

Namespace: Syncfusion.GridHelperClasses

Assembly: Syncfusion.GridHelperClasses.Windows.dll

Syntax

public class GridForeignKeyHelper : Object

Constructors

GridForeignKeyHelper()

Initializes a new instance of the GridForeignKeyHelper class.

Declaration

public GridForeignKeyHelper()

Methods

SetupForeignTableLookUp(GridGroupingControl, String, DataTable, String, String)

Sets up a foreign key relation.

Declaration

public static void SetupForeignTableLookUp(GridGroupingControl grid, string valueColumnInMainTable, DataTable foreignDataTable, string valueMemberInForeignTable, string displayMemberInForeignTable)

Parameters

Type	Name	Description
GridGroupingControl	grid	The grouping grid.
System.String	valueColumnInMainTable	Parent column.
System.Data.DataTable	foreignDataTable	Foreign table.
System.String	valueMemberInForeignTable	Child value column.
System.String	displayMemberInForeignTable	Child display column.