Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multi table DataSet - Auto Increment question

Status
Not open for further replies.
Stat792

Stat792

Programmer
Jan 7, 2004
12
0
0
US
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?
 
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
TWO table with the same classname 1
Replies
3
Views
142
Andrzejek
Andrzejek
Swi
  • Locked
  • Question
API - multipart/form-data
Replies
3
Views
252
Swi
Swi
sal21
  • Locked
  • Question
get data from iframe and table
Replies
0
Views
78
sal21
sal21
sal21
  • Locked
  • Question
WHY! ie dont show the table of result 1
Replies
8
Views
151
sal21
sal21
sal21
  • Locked
  • Question
DRAG AND DROP question. 1
Replies
5
Views
142
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top