questionary 0 Newbie Poster

Hi,

how can I display on a single page(View) data from two tables in my db?
In my project the model is *.edmx file.
i have two table one with categories, and the second one with products. All I want to do is to display on home page(view) in left column all categories, and all products in right column. After clicking on category in left column, in right column there should be products form category which was clicked....

project must be written as asp.net mvc2 web application.

regards