How do I run this SQL query in VB.NET?

Question

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 UPDATE command. How do I convert and run this in VB.NET?

DECLARE @Rt int
SET @Rt = 0

UPDATE DB.dbo.Sales
SET @Rt = Total = @Rt + Area1 + Area2
FROM DB.dbo.Sales

Anuraj · Accepted Answer · 2011-04-10 09:24:45Z

7

Try this

Dim query as string = "UPDATE DB.dbo.Sales SET @Rt = Total = @Rt + Area1 + Area2 FROM Sales"
Dim updateCommand as new SqlCommand(query, SqlConnection)
updateCommand.Parameters.AddWithValue("@rt",0)
If 0 <> updateCommand.ExecuteNonQuery() Then 'Number of rows affected by the query
'Update command was successfull.
End If

edited Apr 10, 2011 at 9:24

answered Apr 10, 2011 at 8:26

Anuraj

19.7k7 gold badges61 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Miquash Over a year ago

Mr. Anuraj I proved about you the code is very very useful to me. Since long time I was stuck with this code. Thanks a lot.

Collectives™ on Stack Overflow

How do I run this SQL query in VB.NET?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related