Show data relationship in gridview with dropdownlist or similar?
- by Anders Svensson
I have data coming from two tables with a foreign key relationship - one User table containing users of the web application, and one Page table containing details about pages visited by each user.
I would like to be able to view these data in a gridview or the like on a page. It's easy enough to just show the User table data like so (I'm using the Entity Framework and LINQ):
UserDBEntities context = new UserDBEntities();
GridView1.DataSource = from user in context.UserSet
select new { user.Ip, user.Count, user.Description, user.Referer };
GridView1.DataBind();
But how can I show the Page details? I'm not bent on any particular way of showing it, but the only idea I've been able to come up with is to have a dropdown list for each user in a column. But I can't figure out how to get the page data into such a dropdown list. The tables are associated with the primary/foreign key UserID.
Any ideas would be welcome (dropdownlist solution or other)!
