C# DevExpress XtraGrid, bind to property of nested class

Question

It's easy to bind an XtraGrid control to a class by setting the FieldName for each column to the name of a property in the underlying class. We have now encountered a situation in which we would like to display data from a class nested in the underlying class.

i.e. we have a "User" class which contains a property called "Address" which is another class called "Address". Within Address are properties like Street, City etc.

We would like to display on the grid the UserName (from User class) and Street (from the Address class). Is this possible?

Please note that Address is not a List, it is a class nested inside of the User class.

We have tried setting the grid column FieldName to "Address.Street" however this doesn't work to pickup the data. I am hoping that this is possible, it seems an elementary feature to not support.

Answer 1

Lets assume you have the following classes in your code.

1) Address class

public class Address {
    public string Street { get; set; }

    public string City { get; set; }
}

2) User class

public class User {

    public string UserName { get; set; }

    public Address UserAddress { get; set; }
}

Now, that you want to bind a column Street to property User.Address.Street, this unfortunately wouldn't work by simply setting FieldName to "Address.Street"

But, if it is important that you accomplish it the way you want, I would suggest that you override the ToString() method of the Address class as follows:

public class Address {
    public string Street { get; set; }

    public string City { get; set; }

    //Override ToString() method
    public override string ToString() {
        return this.Street;
    }
}

Then, set the field name to "Address", instead of "Address.Street" which should do the trick.

Also another approach would be to add another readonly property called UserStreet in the User class:

public class User {

    public string UserName { get; set; }

    public Address UserAddress { get; set; }

    public UserStreet {
        get { return UserAddress != null ? UserAddress.Street : ""; } 
    }
}

And then set FieldName to "UserStreet".

Hope this helps.

Answer 2

Yes you can. Add an unbound column and handle CustomUnboundColumnData Event.

Unbound Columns.
http://documentation.devexpress.com/#WindowsForms/CustomDocument1477

CustomUnboundColumnData
http://documentation.devexpress.com/#WindowsForms/DevExpressXtraGridViewsBaseColumnView_CustomUnboundColumnDatatopic

Answer 3

I solve my same bankCode field problem like this;

public class BankAcc : IJPObject
{
    public string uuid { get; set; }
    public int internal_Reference { get; set; }
    public int accountType { get; set; }
    public string accountTypeInfo { get; set; }
    public string code { get; set; }
    public string description { get; set; }
    public string accountNr { get; set; }
    public string iBAN { get; set; }
    public string bankCode { get { return bankRef != null ? bankRef.bank_Code : ""; } set { bankCode = value; }}
    public Bankref bankRef { get; set; } = new Bankref();
}

public class Bankref
{
    public int reference { get; set; }
    public string bank_Code { get; set; }
}

Answer 4

NestedClass.Property just add like regular properties.

e.g.:

       settings.Columns.Add(column =>
    {
        column.Caption = "NestedClass";
        column.FieldName = "NestedClass.DataEntry";
        column.Name = "NestedClass";

    });

best approach remains using the unboundcolumns. But this works...