tags:

views:

3378

answers:

1
+2  Q: 

Select rows in dataset table based on other dataset table

I have a dataset that has two tables in it. I want to do the following (or something like it) is it possible and is how I have it correct?

        dsTabData.Tables("FilingTabs").Select("fs_ID not in (select fsp_fsid from ParentTabs)")

how do you reference data from other table in the same dataset?

+1  A: 

ok ok before y'all flame me! ;)

I did some more looking around online and found what looks like the stuff I need, now off to read some more from here:

Navigating a Relationship Between Tables

MikeScott8  2008-09-12 23:25:14

related questions

Subsonic Vs NHibernate
How to check For File Lock in C# ?
Is nAnt still supported and suitable for .net 3.5/VS2008?
Limit size of Queue<T> in .NET?
Viewstate invalid when using Safari
Free OCR library
Unhandled Exception Handler in .NET 1.1
Localising date format descriptors
Get a new object instance from a Type in C#
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
.NET Testing Framework Advice
Embedded Database for .net that can run off a network
Automatically update version number
Homegrown consumption of web services
How do you migrate a large app from VB6 to VB .net ?
.NET Migrations Engine
Adding Scripting functionality to .NET applications
SQLite and XSD
Floating Point Number parsing: Is there a Catch All algorithm?
How do I programmatically create a PDF in my .NET application?
How do I sync the SVN revision number with my ASP.NET web site?
XSD DataSets and ignoring foreign keys
Anatomy of a "Memory Leak"
Reliable Timer in a Console Application
How do I calculate relative time?