Reolad Data in gird grouping control

[franco perduca]

Hi all

I have a gridgrouping control that load the data with code taken from your site (see below) and it works fine.

In the code I setup also some filter , hide some colums, set some other columns to read only  ecc.

Now I need to reload the data , how is possibile to achieve this and maintain the setup of grid ?

Thank you for yor support

Franco

DataTable parentTable = GetParentTable();
DataTable childTable = GetChildTable();
DataTable grandChildTable = GetGrandChildTable();
GridRelationDescriptor parentToChildRelationDescriptor = new GridRelationDescriptor();

//Same as SourceListSetEntry.Name for Child Table.
parentToChildRelationDescriptor.ChildTableName = "MyChildTable";
parentToChildRelationDescriptor.RelationKind = RelationKind.RelatedMasterDetails;
parentToChildRelationDescriptor.RelationKeys.Add("parentID", "ParentID");

//Adds relation to Parent Table.
gridGroupingControl1.TableDescriptor.Relations.Add(parentToChildRelationDescriptor);
GridRelationDescriptor childToGrandChildRelationDescriptor = new GridRelationDescriptor();

//Same as SourceListSetEntry.Name for Grand Child Table.
childToGrandChildRelationDescriptor.ChildTableName = "MyGrandChildTable";
childToGrandChildRelationDescriptor.RelationKind = RelationKind.RelatedMasterDetails;
childToGrandChildRelationDescriptor.RelationKeys.Add("childID", "ChildID");

//Adds relation to Child Table.
parentToChildRelationDescriptor.ChildTableDescriptor.Relations.Add(childToGrandChildRelationDescriptor);

this.gridGroupingControl1.Engine.SourceListSet.Add("MyParentTable", parentTable);
this.gridGroupingControl1.Engine.SourceListSet.Add("MyChildTable", childTable);
this.gridGroupingControl1.Engine.SourceListSet.Add("MyGrandChildTable", grandChildTable);

this.gridGroupingControl1.DataSource = parentTable;

[Arulpriya Ramalingam]

Hi franco, 

Thanks for using Syncfusion products. 

In GridGroupingControl, If you want the grid settings while reloading the GridGroupingControl, you need to create the separate methods for Grid(GridSettings) then use this method when reload the grid. Please refer the below code and sample, 

Code snippet 

 

public Form1() 

{ 

    InitializeComponent(); 

 

    // DataSource code// 

    

      this.GridSettings(); 

} 

 

#region Grid Settings 

public void GridSettings() 

{ 

    gridGroupingControl1.AllowProportionalColumnSizing = true; 

    //Setting the filter condition. 

    FilterCondition condition = new FilterCondition(FilterCompareOperator.GreaterThan, 50); 

    //Setting the RecordFilterDescriptor 

    RecordFilterDescriptor recordFilterDescriptor = new RecordFilterDescriptor("CategoryID", condition); 

    //Adding the RecordFilterDescriptor to collection 

    this.gridGroupingControl1.TableDescriptor.RecordFilters.Add(recordFilterDescriptor); 

   //To add the hidden columns 

    foreach (GridColumnDescriptor col in this.gridGroupingControl1.TableDescriptor.Columns) 

    { 

        if (!this.gridGroupingControl1.TableDescriptor.VisibleColumns.Contains(new GridVisibleColumnDescriptor(col.Name))) 

        { 

            this.gridGroupingControl1.TableDescriptor.VisibleColumns.Add(col.Name); 

        } 

    } 

} 

#endregion 

 

//Button click Event Customization 

private void reloadBtn_Click(object sender, EventArgs e) 

{ 

    this.gridGroupingControl1.DataSource = null; 

    this.gridGroupingControl1.DataSource = parentTable; 

    this.GridSettings(); 

} 

 

Sample link: http://www.syncfusion.com/downloads/support/forum/130791/ze/ReloadData1996426689  

 

Regards, 

Arulpriya

[franco perduca]

Thank You for your support

Another question 

it's possible to have a filter that work only in parent grid and not in a child ? like this

[Arulpriya Ramalingam]

Hi Franco, 

 

Thanks for your update. 

 

By default the ExcelFiler have the support to filter the parent table only. The GridExcelFilter does not have the support to filter the nested table. Please refer the below UG link to know more about GridExcelFilter and dashboard sample. 

 

UG link: https://help.syncfusion.com/windowsforms/gridgrouping/filtering#excel-like-filter  

Dashboard sample link: <Install location>\Syncfusion\EssentialStudio\<Product version>\Windows\Grid.Grouping.Windows\Samples\Filters and Expressions\Optimized Excel Filter Demo\CS 

 

Can you please provide your requirement so that we could able to provide you a better solution at the earliest. 

 

Regards, 

Arulpriya