get parent id from parentTable to childTable

Pops Fale

I have 2 data Table's which having data except parent and child Id, i am fetching schema for these 2 tables from sql while inserting parent table , using Scope Identity ,able to fetch parent id , but dont know how to add this id to child data table (here child table already have data except id which i have to take from parent table , note : i want to avoid for loop to assign parent id to child table ) how can i achieve this , i am not expecting any code but want some hint do this

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pops Fale9y ago
you can find my code here : http://stackoverflow.com/questions/41196973/insert-parenttable-id-into-child-table-using-scope-identity-by-using-adapter-in, note that parent table have record for which parent id is using scope identity and this parent id will be updated in child table ( here child table already have data , we have to fill this parent id in child table without for loop.) then after this we have to insert data in sql table by using adapter.update() method
(check image file attached on stack overflow link)
Thanks.
0
Nitin Sontakke9y ago
I wish you could share some sample data. Any code that you attempted, etc.

Where is this happening? In a stored proc? It is also not clear if data is already there you only intend to enforce relationship. If yes, what is the basis?

Somehow, at least for me, it is very difficult to imagine what exactly you are trying to do.
0