Working with DataSets with VB Code

[donutman]

I'm trying to mimic DataSet table queries within VB code that are simple as pie in SQL Server. Another words I want to work with the data tables in vb and perform e.g. left joins that can then be used to create a new table within the DataSet that contains only rows from Table A that are not "matched" in Table B. Can that be done within VB itself once Table A and Table B are within a vb DataSet? If so what does the code look like?
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[MajP]

See the following

http://msdn.microsoft.com/en-us/library/bb386921.aspx

 

[donutman]

Thanks MajP. While the link didn't really answer the question it pointed me in the right direction. My good fortune that you happened to visit this forum rather than Access.
Rod Stephens Chapter on LINQ did the rest. Awesome, would never have studied that chapter otherwise, i.e. would have "skipped while".
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]