Assume that you're working with a dataset that contains two tables, and these tables share a relationship.
Table1:
Column1 (PK) (AutoIncrement)
Cloumn 2
Table2:
ColumnA
ColumnB (foriegn key to table1.Column1)
How can you insert rows into table1, and insert related rows into table2 before updating the dataset to the database?
Table1:
Column1 (PK) (AutoIncrement)
Cloumn 2
Table2:
ColumnA
ColumnB (foriegn key to table1.Column1)
How can you insert rows into table1, and insert related rows into table2 before updating the dataset to the database?