VB.Net - SQL Table Value Increment and Select

Good Day Experts!

I have been tasked with creating a VB.Net version of some VB6 code.  It is conceptually simple but I am not sure how to attain it in VB.Net.  I have a SQL table with 1 field that is numeric...it is NextOrderID.  

I have to Select that NextOrderID to use but then Update in the same statement for the next person to use.  

Is there a simple way to do this all in one statement?

Please ask questions as I probably didn't explain it very well.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Éric MoreauSenior .Net ConsultantCommented:
in a single statement, no but you can create a transaction to be sure that your action is valid even in multi user environment:

UPDATE dbo.TableRowId
SET LastRowId = LastRowId + 1
WHERE TableName = 'upload'

SELECT LastRowId FROM dbo.TableRowId WHERE TableName = 'upload'


Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jimbo99999Author Commented:
Excellent idea...it is working now.

Thanks for the help,
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.