开发者

Inserting relational data using Dataset

开发者 https://www.devze.com 2023-03-15 13:35 出处:网络
I have two tables with Pk and Fk relationship.When i insert into one table(EventLog table) i get a logID(autogenerated) now i need to insert into the second table (EventErrorLog table).

I have two tables with Pk and Fk relationship.When i insert into one table(EventLog table) i get a logID(autogenerated) now i need to insert into the second table (EventErrorLog table).

The addrow method

public LOG_FIRE_EventLogErrorRow AddLOG_FIRE_EventLogErrorRow(
    LOG_FIRE_EventLogRow parentLOG_FIRE_EventLogRowByFK_LOG_FIRE_EventLogError_LOG_FIRE_EventLog,
    string errorDescription
)
开发者_运维百科

need a row from EventLog table.How do pass that?


Check:

http://web.archive.org/web/20080531012216/http://sqlserver2000.databases.aspfaq.com:80/can-sql-server-tell-me-which-row-was-inserted-most-recently.html

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号