Dim connStr2 As String = ConfigurationManager.ConnectionStrings("abc").ToString()
Dim conn2 As New SqlConnection(connStr2)
Dim insertValue As String = "UPDATE table1 SET table1.counter = table1.counter +1"
Dim cmd As New SqlCommand(insertValue, conn2)
conn2.Open()
cmd.ExecuteNonQuery()
conn2.Close()
ladinku
Member
194 Points
48 Posts
Re: What would be the equivalent of this in VB.NET ?
May 01, 2012 12:16 PM|LINK
There are a number of conversion tools available. Try Converter.NET it's free or other online like http://www.developerfusion.com/tools/convert/csharp-to-vb/.
In VB:
Dim connStr2 As String = ConfigurationManager.ConnectionStrings("abc").ToString() Dim conn2 As New SqlConnection(connStr2) Dim insertValue As String = "UPDATE table1 SET table1.counter = table1.counter +1" Dim cmd As New SqlCommand(insertValue, conn2) conn2.Open() cmd.ExecuteNonQuery() conn2.Close()HTH