J
Jacek Jurkowski
My application is using an identity field of an SQL Server.
Identity field called "ID" is a Primary Key too. The problem
is when i add some record to the table SQL Server is
assigning it sime new id. But thouse is not returned into a
Data Table so the id number on SQL Server is not equal
thouse in the data table. So when I'm trying for exemple
delete row, it causes an error because UPDATE command
cannot find an ID on the SQL Server equal to the DataSet Table.
Close and re open table solves that problem but is not acceptable
for performance goals ...
How to make DataSet Table to retrieve id from the SQL Server
after insert command?
Identity field called "ID" is a Primary Key too. The problem
is when i add some record to the table SQL Server is
assigning it sime new id. But thouse is not returned into a
Data Table so the id number on SQL Server is not equal
thouse in the data table. So when I'm trying for exemple
delete row, it causes an error because UPDATE command
cannot find an ID on the SQL Server equal to the DataSet Table.
Close and re open table solves that problem but is not acceptable
for performance goals ...
How to make DataSet Table to retrieve id from the SQL Server
after insert command?