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
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: Syncfusion.GridHelperClasses
Assembly: Syncfusion.GridHelperClasses.Windows.dll
Syntax
public class GridForeignKeyHelper
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. |