ASP.Net MVC 4: Showing DATA in Nested Grid View Using jQuery

Project


Figure 1: Project Table

The following is the script of the table:

And the second table is Employee:


Figure 2: Employee Table

The script of the Employee table is:
Now create a new Visual Studio Project.


Figure 3: Creating a new Visual Studio project


Figure 4: Visual Studio Project

Now right-click on the Project Solution Explorer and Add New ADO.NET Entity Data Model as in the following:


Figure 5: Add New ADO.NET Entity Data Model


Figure 6: Choose Model Contents


Figure 7: Connection Properties


Figure 8: Choose your Data Connection


Figure 9: Choose Database objects and settings


Figure 10: Tables are created

Now see the data in the tables, Project and Employee:


Figure 11: Added some data


Figure 12: Employee Table

Now right-click on the Model folder inside your project's Solution Explorer and Add New Item. Now add a new class and name it EmpProject.cs.


Figure 13: New class created

Write the following code snippet.


Figure 14: Code written
Now right-click on Controller and Add New Controller.


Figure 15: Add New Controller


Figure 16: Added Project Controller

Write the following code in the project's Controller:


Figure 17: Code added.