How to filter a dataset using relationships like a sqlcommand - 04-18-2006 , 08:17 PM
I have a dataset with many ralated datatables, i need execute filter
that gives back datarows to me that gives back to me if outside the
following SQL command.
SELECT distinct GE_SERVICE_TYPE.SERVICE_TYPE_ID,
WHERE PS_PACKAGE_TYPE.PACKAGE_TYPE_ID =
GE_SERVICE_TYPE.SERVICE_TYPE_ID = PS_PRODUCT_TYPE.SERVICE_TYPE_ID
AND (CC_PRODUCTS_BROCHURE.MARKETING_SEGMENT_ID = :MARKETING_SEGMENT_ID)
Which is the best way to obtain this?
Thanks beforehand for the collaboration.
Re: How to filter a dataset using relationships like a sqlcommand - 04-19-2006 , 12:59 AM
As I see it as this, why don't you than get it as a datatable fromt he
databaseserver using this select?
"Alvaro E. Gonzalez" <AGonzalezv (AT) gmail (DOT) com> schreef in bericht
news:OgjnEe0YGHA.3532 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
Re: How to filter a dataset using relationships like a sqlcommand - 04-20-2006 , 08:18 AM
In addition to Cor's comments.
What are you expecting back?
It sounds like you want an Exception Join, Data Sets don't support Exception
Joins in fact Data Sets don't directly support any join. There is a JoinView
available as a sample DataView at:
That you might be able to modify to do an Exception Join...
If the (possibly modified) JoinView doesn't do what you want, I would
probably simply iterate over each table copying selected rows I wanted to
keep to a new data table. Alternatively I would iterate over each table
deleting selected row that I did not want to keep. Depending on the
percentage of the results compared to the input...
Hope this helps
Jay B. Harlow [MVP - Outlook]
..NET Application Architect, Enthusiast, & Evangelist
T.S. Bradley - http://www.tsbradley.net
"Alvaro E. Gonzalez" <AGonzalezv (AT) gmail (DOT) com> wrote
|Thread Tools||Search this Thread|