I need to build a table with the results of different LINQ queries. I was trying to do this with a data table but now sure of the syntax. An example of what I'm trying to do is below.
After I add all the columns and create all the other LINQ queries, How do I add/update the data table with the results? Or is there a better way then using a data table? Was I build the table and create calculate columns the end results will end up in an excel spreadsheet.
Using VB 2008 framework 3.5.
Dim ResultsTable as DataTable
Dim dc As New dcDSSDataContext
Dim TMADODList = From TMA In dc.vwCurrentTMA _
Dim InterChgDODList = From IC In dc.datInterchangeableDOD _
Dim DODList = TMADODList.Union(InterChgDODList )
DODList = DODList.Distinct
ResultsTable = New DataTable("Results")
'Other columns added here