How to create view to display data from the below controller?

Question

0.00/5 (No votes)

See more:

I am new in ASP.Net. I would like to retrieve data from table Student (StudentID, StudentName, MajorID, ...) and Major (MajorID, MajorName, ...).
In my controller:

C#

public class MajorController : Controller{    
    MajorEntity majorEntity = new MajorEntity();
    StudentEntity studentEntity = new StudentEntity();    

    public ActionResult Index(){
        var major = new List<MAJOR>(majorEntity.MAJORs);
        var student = new List<SUTDENT>(studentEntity.STUDENTs);
        var result = from s in student join m in major on s.MajorID equals m.MajorId select new {s.StudentName, m.MajorName };        
        return View(result);
    }
}

Posted 13-Feb-12 22:05pm

Bun Leap_kh

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aniket Yadav · Answer 1 · 2012-02-13T22:12:00

Solution 1

You have two tables named Student and Major... So,

SQL

SELECT Student.StudentName, Major.MajorID FROM Student INNER JOIN Major ON Student.MajorID = Major.MajorID

If any further query then feel free to ask.

Posted 13-Feb-12 22:12pm

Aniket Yadav

Updated 13-Feb-12 22:14pm

v2

Comments

Bun Leap_kh 14-Feb-12 4:37am

But I am using ADO.Net Entity Data Model.
Actually, I got the result in controller, but I couldn't create view.
I would like to know how to create view according to this result?
Thanks for your response!

Aniket Yadav · Answer 2 · 2012-02-13T22:54:00

Solution 2

this link will help you

http://msdn.microsoft.com/en-us/library/aa697427(v=vs.80).aspx[^]

Posted 13-Feb-12 22:54pm

Aniket Yadav

BobJanova · Answer 3 · 2012-02-13T23:46:00

You're passing the collection of objects to the view, so all you have to do is read them out and create a table. This is pseudocode because I don't have all the docs to hand and I don't use ASP.net that much, but:

<Page Class="System.Web.Mvc.Page<IEnumerable<StudentSubject>>"/>

<html>
<body>
<table>
<%
foreach(StudentSubject ss in Model)
 Response.WriteLine("<tr><td>" + HtmlUtils.Escape(ss.StudentName) + "</td><td>" + ss.Subject + "</td></tr>");
%>

</table>
</body></html>

You'll also have to use a real class, not an anonymous one, so you can reference it in the view:

public class StudentSubject {
 public string StudentName, Subject;

 internal StudentSubject(string name, string subject){
  this.StudentName = name; this.Subject = subject;
 }

...
var result = from s in student join m in major on s.MajorID equals m.MajorId select new StudentSubject(s.StudentName, m.MajorName);