Dataset XML Select

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

aconrad
Wed Mar 09 12:54:25 CST 2005

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

Reg
Wed Mar 09 13:29:05 CST 2005

Thank you very much for your help

""Andrew Conrad"" wrote:

> 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
>
>

Val
Wed Mar 09 19:10:25 CST 2005

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

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"Reg" <Reg@discussions.microsoft.com> wrote in message
news:79C3AE04-83AD-4E7A-B639-6C921D4CC6C4@microsoft.com...
> 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