Hi All,
I have an ultragrid that groupby "date" and "order number". I have a DataTable consists of 3 columns and 2 rows. My goal is to add this DataTable to child row as shown in the attached image, when the user clicks on the number 15(column G).
Please advise.
I'm not sure if you want to add this DataTable to the Excel spreadsheet after exporting the grid, or if you were just using Excel to illustrate your objective...if you want to display a grid within a grid, i.e., "add this DataTable to child row", you can theoretically do this using an UltraControlContainerEditor with an UltraGrid contained within it. The control container editor would then be assigned to a cell's EditorComponent property, and would display within that cell.
Hi,
I am using the excel spreadsheet to illustrate how i want my data to look like. Do you have any UltraControlContainerEditor example codes ?
Thanks
See here:
http://help.infragistics.com/Help/NetAdvantage/WinForms/2011.1/CLR2.0/html/WinControlContainerEditor_Embed_Any_Control_within_WinGrid_Cell_using_UltraControlContainerEditor_Component.html
I think you misunderstood my question there. I want to be able to display my display in a treeview mode. For Example: Record ID Company Name Contact Name
-1222 IBM Joe
Contact Title Contact age Office Number
Analyst 35 6500
-1223 Microsoft John
Business Analyst 29 5500
Do you have any sample codes for this?
In order to display hierarchical data in the grid, you must bind the grid to a hierarchical data source.
There are many possible data source you can use, but typically, you would use a DataSet with two tables and a relationship between them to display something like you have here.
There are many samples included with NetAdvantrage that do this. There are also some help topics to show you how:
http://help.infragistics.com/Help/NetAdvantage/WinForms/2011.1/CLR2.0/html/WinGrid_Accessing_Data.html
It works perfectly. Thanks Mike!