Syncfusion.Windows.Forms.Tools.DataRelation

[Kevin Xiao]

I use the  demo of treeviewadv  demo“data binding”

use  two table get treeview ，but I failed ，

I use code as

this.MineFaceTable.Columns.Add("MineFaceID", typeof(int));

            this.MineFaceTable.Columns.Add("MineFaceName", typeof(string));

            this.MonitoringPointTable.Columns.Add("MonitoringPointID", typeof(decimal));

            this.MonitoringPointTable.Columns.Add("MonitoringPointName", typeof(string));

            this.MonitoringPointTable.Columns.Add("MineFaceID", typeof(int));

            string MineFacesql = "Select MineFaceID,MineFaceName from MineFaceList";

            SQLiteDataReader MineFaceobjReader = SQLiteHelper.GetReader(MineFacesql);

            DataTable MineFaceTable = RockBurstDAL.SQLiteHelper.GetDataSet(MineFacesql).Tables[0];

            string MonitoringPointsql = "Select MonitoringPointID,MonitoringPointName,MineFaceID from MonitoringPointList";

            DataTable MonitoringPointTable = RockBurstDAL.SQLiteHelper.GetDataSet(MonitoringPointsql).Tables[0];

            ChildRelation1 = new Syncfusion.Windows.Forms.Tools.DataRelation(MonitoringPointTable, "MonitoringPointName", "MineFaceID");

            treeViewAdv1.DataRelations.Clear();

            this.sfDataGrid1.DataSource = MineFaceTable;

            this.sfDataGrid2.DataSource = MonitoringPointTable;

            treeViewAdv1.DisplayMember = "MineFaceName";

            treeViewAdv1.ParentMember = "MineFaceName";

            treeViewAdv1.ChildMember = "MineFaceID";

            treeViewAdv1.DataRelations.Add(ChildRelation1);

            treeViewAdv1.DataSource = MineFaceTable;

the MonitoringPointName are all in every MineFaceName ，that is error。

[Subburaj Pandian Veluchamy]

Hi Kevin, 

  

Thank you for Contacting Syncfusion Support. 

  

We can able to reproduce the reported behavior with “Data relation of TreeViewAdv” and we have confirmed it is a defect. We have logged the report for the same and the patch for this fix will be available on or before August 27, 2019. We appreciate your patience until then.  

   

You can track the status of the report by the following feedback link,

 

https://www.syncfusion.com/feedback/8120/datatable-with-int-data-type-is-not-bind-properly-in-treeviewadv 

  

Note: The provided feedback link is private, and you need to login to view this feedback. 

 

Regards,
Subburaj Pandian V  

[Kevin Xiao]

Thanks

[Dinesh Babu Yadav]

Hi Kevin, 

 

Thanks for the update. We will update you once the release is roll out and will appreciate your patience until then. 

 

Regards, 

Dinesh Babu Yadav 

[Jagadeesan Pichaimuthu]

 Hi Kevin Xiao,

The issue with “Data relation of TreeViewAdv” has been fixed and the patch for this fix can be downloaded from the following location.    

 

   

Recommended approach - exe will perform automatic configuration
Please find the patch setup from below location: 

http://syncfusion.com/Installs/support/patch/17.2.0.34/1175422/F146554/SyncfusionPatch_17.2.0.34_1175422_8272019024945466_F146554.exe 

 
Advanced approach – use only if you have specific needs and can directly replace existing assemblies for your build environment
Please find the patch assemblies alone from below location: 

http://syncfusion.com/Installs/support/patch/17.2.0.34/1175422/F146554/SyncfusionPatch_17.2.0.34_1175422_8272019024945466_F146554.zip 

 

Nuget: 

http://syncfusion.com/Installs/support/patch/17.2.0.34/1175422/F146554/SyncfusionNuget_17.2.0.34_1175422_8272019024945466_F146554.zip
   

Assembly Version: 17.2.0.34 

Installation Directions : 
This patch should replace the files “” under the following folder.
$system drive:\ Files\Syncfusion\Essential Studio\$Version # \precompiledassemblies\$Version#\
Eg : $system drive:\Program Files\Syncfusion\Essential Studio\17.2.0.34\precompiledassemblies\4.6\

To automatically run the Assembly Manager, please check the Run assembly manager checkbox option while installing the patch. If this option is unchecked, the patch will replace the assemblies in precompiled assemblies’ folder only. Then, you will have to manually copy and paste them to the preferred location or you will have to run the Syncfusion Assembly Manager application (available from the Syncfusion Dashboard, installed as a shortcut in the Application menu) to re-install assemblies.

Note : 
You can change how you receive bug fixes by navigating to the following link and updating your preferences.
https://www.syncfusion.com/support/directtrac/patches

Disclaimer : 
Please note that we have created this patch for version specifically to resolve the following issue reported in the forum- #146554
If you have received other patches for the same version for other products, please apply all patches in the order received. This fix will be included in our Vol 3 release which will be available in September, 2019.

Regards, 

Jagadeesan