Complex tables in MVC 4

tkarwalawrb

It's my first time here , so i want to say hello:)

I'm beginner .NET developer and few days ago I've started new project. I need to show data from database in specific table:

I problem: one table with collapsing rows:
RoadFirst
--1Addres (by IdRoad)
----1ProductFirstType (by IdAddres)
----2ProductFirstType (by IdAddres)
----1ProductSecondType (by IdAddres)
----2ProductSecondType (by IdAddres)
--2Addres (by IdRoad)
----1ProductFirstType (by IdAddres)
----2ProductFirstType (by IdAddres)
----1ProductSecondType (by IdAddres)
----2ProductSecondType (by IdAddres)

II problem: three different tables on one page. Only first table is fill by data (Roads).
When I select row in first table, the second should fill in Addresses (by selected IdRoad).
When I selec the Adress, the third should fill in ProductFirstType and ProductSecondType (by idAdress).


I've tried many solutions with native MVC WebGrid, but nothing. Now I discovered this project.
Can you tell me, is it possible to solve my problems with DataTables?

Mayby somebody can help me and show example code with solution. It's very important for me, because I need to to show something to my boss in tuesday.
I would be wery grateful for your help!

rpanesar

You could use JQuery Tabs to have 3 separate datatables on one page, from which you can use TableTools single selection option to send JSON data to table to table.