D
daveL
Hello,
c#2 , sqlserver 2005
I am parsing a Text File into 2 Datatables
Parent we'll say invoice
child well say Invoice Items
parent rows 10,000, child rows 30,000
the 2 Tables start out Empty, i get the table structures from the Database
"select top 0 from parenttable")
same for the items Table, then i parse the text file into
the 2 Datatables Disconnected from Server
My question is....when inserting into the database
how am i to get the child rows (items) the id key of the parent to complete
the relation in a Batch Update
or do i need to make dynamic sql with @@identity
and insert 1 row Parent set child ids then insert the child rows
is there a example of how to accomplish this with dataset,datatables and
sqlAdapter
Thanks
c#2 , sqlserver 2005
I am parsing a Text File into 2 Datatables
Parent we'll say invoice
child well say Invoice Items
parent rows 10,000, child rows 30,000
the 2 Tables start out Empty, i get the table structures from the Database
"select top 0 from parenttable")
same for the items Table, then i parse the text file into
the 2 Datatables Disconnected from Server
My question is....when inserting into the database
how am i to get the child rows (items) the id key of the parent to complete
the relation in a Batch Update
or do i need to make dynamic sql with @@identity
and insert 1 row Parent set child ids then insert the child rows
is there a example of how to accomplish this with dataset,datatables and
sqlAdapter
Thanks