[Solved] How to bind data with IEnumerable?

[Billy Pham]

Hi all,

I tried to bind data in onDataNeed function of a radgrid with IEnumerable as the code below. Remember DisplayComponent is just a temporary class, not a table that I created to store the results. The ExecuteQuery runs without any trouble. However, I cannot bind the to the radgrid. Anyone knows why?

protected void viewBookings_OnNeedDataSource(...)
{
            string s_query = "select distinct bk.Start, fi.FacilityName, bk.Username " +
                              "from Booking_Form as bk, " +
                                    "Facility_Item as fi " +
                              "where bk.FacilityID = fi.ID";

            IEnumerable<DisplayComponent> results = data.ExecuteQuery<DisplayComponent>(s_query);

            viewBookingsGrid.DataSource = results.ToList();
}

        public class DisplayComponent
        {
            public string FacilityName, Username;
            DateTime Start;

            public DisplayComponent()
            {
            }
        }

[Vlad]

Hello Billy,

If the grid does not have columns this is caused by the fact that DisplayComponent class does not have any public properties. FacilityName and Username actually are fields!

Kind regards,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.