Dim connStr2 As String = ConfigurationManager.ConnectionStrings("abc").ToString() Dim conn2 As SqlConnection = New SqlConnection(connStr2) Dim insertValue As String = "UPDATE table1 SET table1.counter = table1.counter +1" Dim cmd As SqlCommand = New SqlCommand(insertValue, conn2)
conn2.Open()
cmd.ExecuteNonQuery()
conn2.Close()
Please "Mark as Answer" if this post helps.Thank You :)
AmalO.Abdull...
Contributor
3116 Points
764 Posts
Re: What would be the equivalent of this in VB.NET ?
May 01, 2012 12:17 PM|LINK
Dim connStr2 As String = ConfigurationManager.ConnectionStrings("abc").ToString()
Dim conn2 As SqlConnection = New SqlConnection(connStr2)
Dim insertValue As String = "UPDATE table1 SET table1.counter = table1.counter +1"
Dim cmd As SqlCommand = New SqlCommand(insertValue, conn2)
conn2.Open()
cmd.ExecuteNonQuery()
conn2.Close()