Multiple Gridview mantaining LINQ relationships
-
Hello, I try to explain as best as I can what I'm trying to do: 1)I'm writing a web app using ASP.NET / FW 3.5 and LINQ to SQL. 2)I've got a table called Categories {id, description} and SubCategories {id,parentid, description} 3)I've got two gridview binded to the tables above with LinqDataSource (tried with a single data source and 2 different one) Even if on db there's a relationship between Categories and SubCategories I can't find an easy way to have the second gridview (the subcategories one) binded to the first one. right now I'm doing the "binding" between the two manually, getting the selected row from first and digging to get the id, but I don't like it much, since sometimes category grid view loses the selectedrow property. Is somewere an example or tutorial about how can I do it in the best way? Thanks Bests