How to retrieve and show data from Multiple table in index?

Question

Hi I want to retrieve and show the data from multiple table in MVC4. i will explain my issue with one example.

In this view i have max 22 fields

When i enter all the details and click the save button it will save the details in that appropriate tables.

Now i want i show the details in Index page.

My Table

Customer

CustomerID uniqueidentifier primary key not null,

DisplayName Varchar(100) null,

PrintName Varchar(100) null,

CustomerTypeID uniqueidentifier null,

Employee

EmployeeID uniqueidentifier primary key not null,

DisplayName varchar(100) null,

VisitorsForm (Main Table)

VisitingID uniqueidntifier primary key not null,

CustomerID uniqueidentifier null,

EmployeeID uniqueidentifier null,

PovisitID uniqueidentifier null,

DepartmentID uniqueidentifier null,

DesignationID uniqueidentifier null,

NextActivityID uniqueidentifier null,

Nextappointment DateTime null,

Description varchar(max)null

Department

DepartmentID uniqueidentifier primary key not null,

DisplayName varchar(100) null,

PrintName varchar(100), null

Designation

DesignationID uniqueidentifier primary key not null,

Designation varchar(100) null,

Designation varchar(100), null

POVisit

POVisitID uniqueidentifier primary key not null,

POVisit varchar(100) null,

Next appointment

NextAppointmentID uniqueidentifier primary key not null,

NextAppointment varchar(100) null,

Now i want to create a index page same as like which is mentioned in the below image

Now Povisit, NextAppointment, Department, designation, CustomerName , Employee name are dropdowns. Suppose i wrote inner join query to show the details means when one dropdown field value is null means i wont show that record. Now any one give idea how to retrieve and show the data in index page using MVC4? I tried my level best to explain my issue. please any one give me solution.

Advance thanks...

ramya bharath · Answer

This is one of my sample query (from jobPost in _context.jobPostingDetail join jobApplied in candidateDetail.candidateJobsApplied on jobPost.JobPostingDetailId equals jobApplied.JobPostingDetailId where (jobPost.CurrentStatus == JobStatus.Waiting.ToString()) && (jobPost.JobPostingDetailId != jobApplied.JobPostingDetailId) select jobPost).ToList() ?? new System.Collections.Generic.List (); So the query for your scenario should be () listView= (from VisitorForm _context.VisitorForm join desigin DesigTable on VisitorForm .designation equalsdesig.Id join customer customerTable on VisitorForm .customer equals desig.Id where VistorForm.DesignatioId!=null select VisitorForm ).ToList() ?? new S () ;

Krishna Rajput Singh · Answer

Hi Sneha Dhandapani below links helpful for you. http://www.codingcage.com/2014/12/fetch-data-from-multiple-tables-in-php.html http://forums.asp.net/t/1700177.aspx?How+to+Display+Data+in+a+single+view+from+Multiple+Tables+in+MVC+3+0+ if find helpful mark as correct answer

Sneha Dhandapani · Answer

Ramya can you explain your answer with one example.

ramya bharath · Answer

You can solve your problem with linq query where you can join the tables using the id and proceed . You have mentioned that you have used inner join where null data comes you have to skip which you can mention it in where condition accordingly to avoid it.