I m trying to insert records into two related tables(Products , ProductDetails) of dataset (ProductDS). The relationship is parent -child with cascade settings.
Following is the code :
dataAdapter.Upd ate(ProductsDS, "Products")
dataAdapter.Upd ate(ProductsDS, "ProductsDetail s")
however after the first update the RowState property of ProductDetals get set to UnChanged and the rows of this table are not inserted.
what setting would keep the Rowstate Added , so that the child rows get inserted ?
Following is the code :
dataAdapter.Upd ate(ProductsDS, "Products")
dataAdapter.Upd ate(ProductsDS, "ProductsDetail s")
however after the first update the RowState property of ProductDetals get set to UnChanged and the rows of this table are not inserted.
what setting would keep the Rowstate Added , so that the child rows get inserted ?