Getting GrandParent columns with ADO.NET
Posted by: JohnPapa.net,
on 23 Apr 2005 |
View original | Bookmarked: 0 time(s)
I've recently had a flurry of email asking how to navigate up to a grandparent table using ADO.NET. Assuming that it is not preferable to export all of the data to Xml and use an XPath, ADO.NET offers a few other ADO.NET based solutions. One solution is to use expression based columns. (If you want more of an explanation of how to use expression based columns in ADO.NET, see my Data Points article here in MSDN Magazine.) To explain both solutions, I created a DataSet that contains 3 DataTables....