sql = "SELECT ServFile.ServProc, ServFile.ServDuration, " & _ "ServFile.ServGapDuration, ServFile.ServFinishDuration, Procedures.ProcDescr " & _ "FROM ServFile " & _ "LEFT JOIN Procedures ON ServFile.ServProc = Procedures.ProcKey " & _ "WHERE ServDes = " & Param1 & " AND ServProc = " & Param2 & " Order by ServProc" 'Lets assume that i have a dataset named dsServices and i fill it with the 'following two queries. Select * From ServFile, Select * From Procedures ' Now what i want to do is query the dataset with linq so that i am joining the ' two tables located in my dataset to get the same results as my original query. ' then i would like to convert it back to a datatable using the CopyToDataTable ' method ' Now that i have this table it will fit right back into the flow of my ' algorithm with minimal changes. Examples would be appreciated. thanks in advance
From novice to tech pro — start learning today.