Dataset XML Select

[Guest]

Hello,

I use VB.net
I have a XML file and I read it with a dataset :
myDS.readxmlschema("test.xsd")
myDS.readxml("test.xml")

I have 3 tables in my dataset. Is it possible to select easily data like
with SQL ?
ex. Select name from Table1 Where region = (Select num From Table2) ....


Thanks for your help

 

[Andrew Conrad]

You can do it with Sql, but DataSet does provide an expression service for
searching on results.

See DataTable.Select() for more info:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/
frlrfsystemdatadatatableclassselecttopic.asp

Andrew Conrad
Microsoft Corp

 

[Guest]

Thank you very much for your help

 

[Val Mazur \(MVP\)]

Hi,

There is no support of the SQL statements for the dataSets, but you could
use approach described in a next KB article.

http://support.microsoft.com/default.aspx?scid=kb;en-us;555267