Need fill all DataTable in a DataSet

microsoft.public.dotnet.framework.adonet

3 Jul 2006 7:31 AM

I have two table in a DataSet. I have set a master-detail relation between
then.

I thought if I fill the master datatable, the detail table will
automatically be filled. but the truth is not.

How can I make my thought to b be true?

4 Jul 2006 2:00 PM

Cowboy (Gregory A. Beamer)

Make a stored procedure that has two select statements. Fill the parent
first, or you WILL have an exception thrown.

You can also do this by batching the statements with a semi-colon:

SELECT * FROM Table1;SELECT * FROM Table2 JOIN Table1 ON Table1.Col1 =
Table2.Col1

etc.

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************

Show quote

"ad" <fly***@wfes.tcc.edu.tw> wrote in message
news:u5m2sRnnGHA.3772@TK2MSFTNGP04.phx.gbl...
>I have two table in a DataSet. I have set a master-detail relation between
>then.
>
> I thought if I fill the master datatable, the detail table will
> automatically be filled. but the truth is not.
>
> How can I make my thought to b be true?
>