Datasets and updating databases , visualbasic datasets , datasets , visual basic Dallas, United States
  • 12 years ago
    I'm updating to a database table that has an autonumber column. For a new entry from my dataset, how do I get the number the database assigns in this column, so I can use it for other tables? So far this column is not being reflected back into my dataset. I need this number to reference it in child tables. (I've seen some suggestions that say use a query to get the max autonumber right after updating. While this is probably the correct entry, I'm not sure it's 100%. What if lots of users are writing several new entries to this database at the same time? What assurance do I have that the max autonumber is necessarily mine?)

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“An idiot with a computer is a faster, better idiot” - Rich Julius