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()
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 :)
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()
hybrid.net
Member
9 Points
15 Posts
What would be the equivalent of this in VB.NET ?
May 01, 2012 12:10 PM|LINK
string connStr2 = ConfigurationManager.ConnectionStrings["abc"].ToString(); SqlConnection conn2 = new SqlConnection(connStr2); string insertValue = @"UPDATE table1 SET table1.counter = table1.counter +1"; SqlCommand cmd = new SqlCommand(insertValue, conn2); conn2.Open(); cmd.ExecuteNonQuery(); conn2.Close();chiragtoad
Member
212 Points
51 Posts
Re: What would be the equivalent of this in VB.NET ?
May 01, 2012 12:15 PM|LINK
check online tool at following link
http://www.developerfusion.com/tools/convert/csharp-to-vb/
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
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()
matelin
Participant
955 Points
294 Posts
Re: What would be the equivalent of this in VB.NET ?
May 01, 2012 12:18 PM|LINK
From http://www.developerfusion.com/tools/convert/csharp-to-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()Matelin