SfDataGrid MasterDetailView set up.
I am new to syncfusion and programming in general. I downloaded the community version of Syncfusion to learn how to build enterprise programs. I am attempting to make a nested table that shows items attached to jobs in the grid much like the example project:
http://www.syncfusion.com/downloads/support/directtrac/general/ze/2230681599446808
Though, after examining this sample I cannot find why or how it works. I do not see where the relations are hooked up or how I get a column on the master table, and a column on the detail table to be related. I also don't understand where the details table comes from, as in this project there is only 1 SfDataGrid, and I see no DataTables being added. Some help in the right direction would be greatly appreciated.
I have attached some screenshots of my project for visual information. I connect to two locally hosted test databasses, one with the inventory, the other with the jobs. The Jobs have a Number column I want to relate to the Allocation ID (allocId) column of the inventory database. I use a DBConnect class amde by myself to connect to both the databases and preform CRUD operations.
Please let me know if more information needs to be provided or if a zipped project would be more helpful.
It makes a little more sense now. I can see what is going on in this example. Yet when I adapted it to fit into my project the details were still not shown beflow the master. I tried changing the function to return a dataset to see if that would fair better instead of returning the first table in the dataset index but that did nothing either. Im getting my jobs table through this method, but it does not seem to be displaying the related items from the items table.
This is my current code with the edits I made. The results are the same as before the edit to return a DataSet instead of the DataTable at index 0.
