I have a need to create a hierarchical grid like in the samples, but my data will not be coming from a straight forward DB query.
For each cell, I will need supporting information that I''ll keep somewhere in an object hierarchy. I would like to bind the hierarchical grid to my own set of classes that are derived from IList, and then each cell could be backed by my own internal data in the class. I can bind a single-level DataBoundGrid to IList source as in the samples, but can this be done to create a hierarchical grid?
If not, another idea:
If my DataSet that contains DataTables contains my own Objects in the rows and columns....what method/interface does the object have to support for the DataBoundGrid to get/set the data for a particular cell?
I tried supporting ToString(), thinking that it would be called to render the data for a cell, but that''s not working, which makes sense...there has to be a way for the grid to SET the data in the DataTable cell when the grid cell changes as well.
Thanks for any help...
ADAdministrator Syncfusion Team June 14, 2004 03:10 PM
You can display an hierarchical custom collection in a GridDataBoundGrid. Take a look at the Grid\Samples\DataBound\Hierarchical\Customers sample.
DADanJune 14, 2004 03:50 PM
Many thanks Clay - I''m looking at it now.
Follow up question:
My objects don''t have pre-defined properties such as FirstName, LastName that would layout as column names across the top. The number of columns and their names are dynamic at runtime based on external data.
Are the properties on the IList derived object the only way the grid knows how to get data from the object? Is there anyway the grid can get data from the underlying objects by INDEX instead of by PropertyName?
ADAdministrator Syncfusion Team June 14, 2004 04:43 PM
You can have your IList object implement ITypedList to expose exactly the objects you want to see from your collection.
Or, you can dynamically set property types at runtime also using a ITypedList implementation. Here is a sample of this latter idea.
DADanJune 14, 2004 05:10 PM
Excellent - thanks Clay, almost there... :)
Now the last piece: I have the ITypedList based collection to bind to a given grid. How do I make the 2nd and 3rd grid relationships for the hierarchical to work out? (the latest enclosed sample produces a single flat grid)
In the standard DataSet based hierarchical grid, I can use DataSet.Relations.Add, then add a corresponding Binder.AddRelation that matches that.
Without a DataSet around, what "relation" do I give to the Binder in the ITypedList scenario?
Thanks!! Great product.
ADAdministrator Syncfusion Team June 15, 2004 02:29 AM
I think you would use the property name of teh child IList property. This is how the hierarchy is set up in the Grid\Samples\DataBound\Hierarchical\Customers sample.