By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,479 Members | 988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,479 IT Pros & Developers. It's quick & easy.

Relationship in Dataset

P: n/a
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
Nov 21 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Nov 21 '05 #2

P: n/a
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
Nov 21 '05 #3

P: n/a
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

Nov 21 '05 #4

P: n/a
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
Nov 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.