Need fill all DataTable in a DataSet

A

ad

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top