Member Avatar for JohnKelly

Dear All

I am using Vb.net to update a database running on SQL Server.

I am using the following to increase the value of the NextPlan in the SystemControl table in a SQL database.

Command.CommandText = "UPDATE SystemControl SET NextPlan = NextPlan + 1"
Command.ExecuteNonQuery()

Once the Command is executed and I look in the actual database I can see the value has been incremented. How can I get the Command to return the new value of NextPlan so I don't need to then do a table read to get the new value.

Thanks

  • 2 Contributors
  • 2 Replies
  • 754 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by JohnKelly
Member Avatar for kRod

Try the following

Dim id as Integer = Command.ExecuteScalar()
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.