Syncfusion.Windows.Forms.Tools.DataRelation

Kevin Xiao

Asked On August 8, 2019 05:59 AM UTC

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。

Reply | Reply with quote

Subburaj Pandian Veluchamy [Syncfusion]

Replied On August 9, 2019 12:30 PM UTC

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

Reply | Reply with quote

Kevin Xiao

Replied On August 14, 2019 05:29 AM UTC

Thanks

Reply | Reply with quote

Dinesh Babu Yadav [Syncfusion]

Replied On August 15, 2019 06:05 AM UTC

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

Reply | Reply with quote

Jagadeesan Pichaimuthu [Syncfusion]

Replied On August 27, 2019 07:23 AM UTC

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

Reply | Reply with quote

Thread ID:	Created:	Updated:	Platform:	Replies:
146554	Aug 8,2019 05:59 AM UTC	Aug 27,2019 07:23 AM UTC	WinForms	4

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US