title: How do I run this SQL query in VB.NET?
body: <p>I'm using SQL Server 2008 and I have this query working successfully, Now my requirement is to execute this code in VB.NET (Visual Studio 2010). It is an <code>UPDATE</code> command. How do I convert and run this in VB.NET?</p>
  
  <pre><code>DECLARE @Rt int
  SET @Rt = 0
  
  UPDATE DB.dbo.Sales
  SET @Rt = Total = @Rt + Area1 + Area2
  FROM DB.dbo.Sales
  </code></pre>