By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,631 Members | 826 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,631 IT Pros & Developers. It's quick & easy.

displaying an auto-incremented identity column

P: 93
Most databases have multiple users. For these databases it is a good idea to auto-increment the identity column.

I understand that the identity column is not incremented until the newly-created record is inserted.

I guess this means the identity column is incremented when you actually reconnect to the database and insert the new record there, rather than just add the record to the locally-resident DataSet, correct?

And I guess this also means that for auto-incremented identity columns it is not possible to accurately display the newly-incremented identity column in the data entry WinForm used to create the new record and add it to the database, right?
Mar 27 '09 #1
Share this Question
Share on Google+
2 Replies


P: 93
Sorry, I should have mentioned the environment:

32-bit
SQL Server 2008 Express with Advanced Services
SQL2008 AdventureWorks
SQL Server 2008 Management Studio Express
Visual C# 2008 Express
Mar 27 '09 #2

ck9663
Expert 2.5K+
P: 2,878
Maybe this will help you.


--- CK
Mar 28 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.