This is a migrated thread and some comments may be shown as answers.

[Solved] What's the SortExpression on a nested object?

5 Answers 198 Views

Grid

This is a migrated thread and some comments may be shown as answers.

diggityDawg asked on 14 May 2008, 06:27 PM

I've got a RadGrid that uses an object collection as it's datasource. Each object/row has it's own collection of objects. When I display the grid I just display the first item in the sub-collection. So, for example, I have a grid of people. Each row is a person. Each person has a collection of addresses. In the "Address" column I have a Label, which I use to put the first address in the collection of addresses (using the OnItemCreated event). How do I specify the SortExpression so that I can sort this grid on the address displayed?

Here's my OnItemCreated method:

    
            protected void RadGrid_ItemCreated(object sender, GridItemEventArgs e)     
        
            {     
        
                Person p = (Person) e.Item.DataItem;     
        
                if (e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem)     
        
                {     
        
                    Label lblAddress = (Label) e.Item.Cells[4].FindControl("lblAddress");     
        
                    if (p.Addresses != null)     
        
                    {     
        
                        if (p.Addresses.Count > 0)     
        
                        {     
        
                            Address address = p.Addresses[0];     
        
                            lblAddress.Text = address.StreetNumber.Trim() + " " + address.StreetName.Trim() + " " +     
        
                                              address.AptNumber.Trim();     
        
                        }     
        
                    }     
        
                }     
        
            }

Thanks!

Eddie

5 Answers, 1 is accepted

answered on 15 May 2008, 03:02 PM

Hi Shinu,

Thanks for your reply. I am using a TemplateColumn. I did see that article, but it doesn't really address my issue. In my TemplateColumn I have a Label control. In my code I build a string out of several data fields in the object, then I set the Text property of the Label to the string I just built. To make matters more complicated, the object I am using is a nested object within the main DataItem for the row. So what field do I use as the Sort Expression. If you look at my code you'll see that I am using address[0].StreetNumber, address[0].StreetName and address[0].AptNumber. But I can't put those into the SortExpression field. I tried building a local variable called "Address" and using that for the SortExpression, but it says there is no field with the name "Address" when I try to execute the code.

Any other ideas I can try?

Thanks,

eddie