How to use Dataset with multi tables ?

[Ing. Rajesh Kumar]

Hi Everybody
I have three tables USERS, ROLES and GROUPS in a SQL Server. As you can
guess, I am using these tables to check permissions. Now I converted these
SQl tables into XML tables and put them into roles.xml and created an
roles.xsd with PK's and FK's. For testing I can load this file into a
Dataset and then display the tables into three different DataGrids as DS(0),
DS(1) and DS(2). Now I
want to get one table based on the combination of these three tables. In The
SQL Server i would use the following command :

SELECT * FROM TABLE1, TABLE2, TABLE3 WHERE TABLE1.ID = TABLE2.ID AND
TABLE1.GROUPID = TABLE3.GROUPID

How to get the same with XML ?
So how can I combine the tables DS.Tables("users"), DS.Tables("roles"),
DS.Tables("groups") ?

Thanks in advance
Raja

[Alvin Bruney [MVP]]

have a look at the merge function of the dataset

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
"Ing. Rajesh Kumar" <iambad(Without This)@post.cz> wrote in message
news:ub**************@TK2MSFTNGP10.phx.gbl...

Hi Everybody
I have three tables USERS, ROLES and GROUPS in a SQL Server. As you can
guess, I am using these tables to check permissions. Now I converted these
SQl tables into XML tables and put them into roles.xml and created an
roles.xsd with PK's and FK's. For testing I can load this file into a
Dataset and then display the tables into three different DataGrids as
DS(0),
DS(1) and DS(2). Now I
want to get one table based on the combination of these three tables. In
The
SQL Server i would use the following command :

SELECT * FROM TABLE1, TABLE2, TABLE3 WHERE TABLE1.ID = TABLE2.ID AND
TABLE1.GROUPID = TABLE3.GROUPID

How to get the same with XML ?
So how can I combine the tables DS.Tables("users"), DS.Tables("roles"),
DS.Tables("groups") ?

Thanks in advance
Raja