如何将数据表里的自增列对应赋给一个datatable

Question

如果是选择，就用 select * from A inner join B on A.xx=B.xx如果是更新，就先更新对应的B表，然后在更新A表

Answer 1

我是先在代码中建了两个datatable：dt1（recordID,EntID,EntName），dt2(RecordID,FileID,EntName)，然后再批量插入的，dt1中的值插入给表A，dt2中的值插入给表B。现在是想实现：
主表                                从表
RecordID*   EntID    EntName        RecordID*     FileID*     EntName1           0001        AA              1         0001           AA                        
2           0002        BB              1         0002           AA                      
3           0003        CC              2         0001           BB                       
                                        2         0002           BB
                                        3         0001           CC
                                        3         0002           CC
                                        3         0003           CC
                                        3         0004           CC......