Hello,

I have 2 related tables named "Orders" and "order details" and the relation is one Order can have many Order Details. I need to insert single values in the Order and a datatable into an OrderDetails. Is it possible and how can I make it. And link or excample will be great:)

Thank You,
G. Kalchev

if you have the values you want to insert stored in the datatable, then you just need to loop through the datatable and construct your Insert statment and exectue it for each pass of the loop.

I sloved it with using "select @@identity"

Thanks you for your time :)