Need fill all DataTable in a DataSet

  • Thread starter Thread starter ad
  • Start date Start date
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?
 
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!
*************************************************
 
Back
Top