sql = "SELECT ProcKey, ProcDescr, ProcGap, ProcDuration, " & _ "ProcGapDuration, ProcFinishDuration, ProcResource FROM " & _ "Procedures WHERE ProcKey IN " & _ "(Select ServProc From ServFile WHERE ServAllowBookOnline = True) " & _ "AND ProcAllowBookOnline = -1 Order by ProcDescr" '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 getting 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.