SfDataGrid not showing inner joined column

[Aleksa Petrovic]

Hello, 

I am using Dapper and when i execute query and load to SfDataGrid only show results from first table.

Model:

public class Users

    {

        public int id { get; set; }

        public string name { get; set; }

        public string email { get; set; }

        public Roles role { get; set; }

    }

public class Roles

    {

        public int id { get; set; }

        public string name { get; set; }

    }

So when i do like

sfDataGrid1.DataSource = results; - Its only show user id, name, email without role name.

Query:

select a.*, b.name from users a inner join roles b on users.roleID = roles.id.

Tables users: id, name, email, roleID.

Table roles: id, name.

[Sampathnarayanan Sankaralingam]

Hi Aleksa, 

 

Based on provided information your requirement to bind the complex property in SfDataGrid can be achieved by setting the complex property path to the MappingName in GridColumn. Please find the code snippet below, 

this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "role.name", HeaderText = "Role Name" }); 

this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "role.id", HeaderText = "Role ID" }); 

Sample Link : https://www.syncfusion.com/downloads/support/forum/171728/ze/SfDataGridDemo1096921326 

For more information related to Binding Complex Properties, please refer the below user guide documentation link, 

UG Link : https://help.syncfusion.com/windowsforms/datagrid/databinding#binding-complex-properties 

Please let us know if you have any concerns in this. 

 

Regards, 

Sampath Narayanan.S 

[Aleksa Petrovic]

Thanks!

[Sampathnarayanan Sankaralingam]

Hi Aleksa,

We are glad to know that the reported problem has been resolved at your end. Please let us know if you have any further queries on this. We are happy to help you😊.

Regards,

Sampath Narayanan.S