Relationship in Dataset

[John]

Hello

could you tell me pls what would be the select statment to relate two tables
in a Dataset; Or do I have to create two select commands for the tables and
then create the reationship in the Dataset!!!? (How?)
Thank U.
--
Regads,
Rochdi

[Terry Olsen]

Look at the SQL "Join" statement. That may do what you need.

"John" <Jo**@discussions.microsoft.com> wrote in message
news:5E**********************************@microsof t.com...

Hello

could you tell me pls what would be the select statment to relate two
tables
in a Dataset; Or do I have to create two select commands for the tables
and
then create the reationship in the Dataset!!!? (How?)
Thank U.
--
Regads,
Rochdi

[Cor Ligthert [MVP]]

John,

could you tell me pls what would be the select statment to relate two
tables
in a Dataset; Or do I have to create two select commands for the tables
and
then create the reationship in the Dataset!!!? (How?)

Exactly

See this sample

http://www.windowsformsdatagridhelp....7-7bc3068aca2c

I hope this helps,

Cor

[Kai Zhang]

Thanks for the link you supplied, Cor Ligthert.

Could you tell me more about the format of the string that used as the
second parameter of function Control.SetDataBinding(param1, param2)?

Thanks,

Kai
"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:%2***************@TK2MSFTNGP10.phx.gbl...

John,

could you tell me pls what would be the select statment to relate two
tables
in a Dataset; Or do I have to create two select commands for the tables
and
then create the reationship in the Dataset!!!? (How?)

Exactly

See this sample

http://www.windowsformsdatagridhelp....7-7bc3068aca2c

I hope this helps,

Cor

[Cor Ligthert [MVP]]

Kai,

Could you tell me more about the format of the string that used as the
second parameter of function Control.SetDataBinding(param1, param2)?

I did not see that in the sample, however probably are you talking about the
datamember as it is in the relation.

Cor