How to Display Data from Multiple Tables in MVC?

Question

0.00/5 (No votes)

See more:

Hi,
I am currently learning MVC 3.0 and have performed basic tasks insert, update etc on on table. Now I was to display my data from multiple tables ( Order and OrderDetail) in one view and also want to insert data in two tables from one view. Please guide me how can I do this? Please don't refer to MVC tutorial link just guide me if you grap up the idea?

Posted 12-Jul-11 21:39pm

touseef4pk

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)

Christian Graus · Answer 1 · 2011-07-12T21:54:00

Solution 1

Simply, you need to select your data with a SQL statement that joins the two tables and gets the data you need. You can also insert data in to as many tables as you want, if you write your own SQL to do it.

Posted 12-Jul-11 21:54pm

Christian Graus

Comments

touseef4pk 13-Jul-11 4:54am

very poor answer...Please read my post thoroughly

saurav_Pandora · Answer 2 · 2011-07-14T08:43:00

Solution 2

By using sql server joins you can easy get data from different tables and if you want to insert data in different table you can use the poco class concept for different fields data to insert in different tables.

Thanks
Saurav Sharma

Posted 14-Jul-11 8:43am

saurav_Pandora

Comments

touseef4pk 15-Jul-11 0:32am

How Can i do this in MVC? What my model should pass to the View?

sasolanki007 · Answer 3 · 2011-09-26T01:32:00

Solution 3

You need to create a ViewModel in which you make instance of both tables and while creating a view refer the view model instead of model.
you can access both tables using the VM.

-Sagar Solanki

Posted 26-Sep-11 1:32am

sasolanki007

Comments

Member 14552976 31-Aug-19 7:43am

can you give such example?