query against XML dataset possible ?

[Guest]

I have an XML file that is strongly typed with a schema & read in to a dataset
Now I thing I would like to 'select on certain criteria' - to create a subset to show in a different grid

Is it possible to do that ? I have yet to find an example.
Or do I have to work with XPath to get a subset

Thanks Andrew

 

[Guest]

Specifically I would like to have an expression like
transactionrecord = dataset.tables["transactionrecord"]

I did find a DataTable.Selec
another method about Compute - which takes some string expression

" Select UNIQUE * from transactionrecord where fieldname_1= 'ERROR'

Is this possible ?? Seems like it might be...
But I dont know what might be supported. In my case I have a windows service running on a serve
and I want to look at the unique errors found during the process. ( The data is logged to a monthly file )

Thanks

 

[Peter Bromberg [C# MVP]]

You can use some of the Find, Filter and Select methods available
in the DataSet, DataTable and DataView classes. check the docs for examples.
Peter

I have an XML file that is strongly typed with a schema & read in to a dataset.
Now I thing I would like to 'select on certain criteria' - to create a

subset to show in a different grid.

 

[Guest]

thanks - I think this is pretty inclusive. http://msdn.microsoft.com/library/d...rfsystemdatadatacolumnclassexpressiontopic.as

I see the syntax is similar to what I might use with a Database. I specifically am looking to also use a 'DISTINCT' type expression to filter out duplicate column entries. Do I have to loop through the data set returned to do that ? Seems that way. Thanks

 

[Jeffrey Tan[MSFT]]

Hi andrewcw,

Thanks for your feedback.

Yes, to do the "DISTINCT" function, you have to determine it through loop
yourself.

If you need further help, please feel free to post.

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.