What would be the equivalent of this in VB.NET ?http://forums.asp.net/t/1798826.aspx/1?What+would+be+the+equivalent+of+this+in+VB+NET+Tue, 01 May 2012 12:18:26 -040017988264959805http://forums.asp.net/p/1798826/4959805.aspx/1?What+would+be+the+equivalent+of+this+in+VB+NET+What would be the equivalent of this in VB.NET ? <pre class="prettyprint">string connStr2 = ConfigurationManager.ConnectionStrings[&quot;abc&quot;].ToString(); SqlConnection conn2 = new SqlConnection(connStr2); string insertValue = @&quot;UPDATE table1 SET table1.counter = table1.counter &#43;1&quot;; SqlCommand cmd = new SqlCommand(insertValue, conn2); conn2.Open(); cmd.ExecuteNonQuery(); conn2.Close();</pre> <p></p> 2012-05-01T12:10:28-04:004959816http://forums.asp.net/p/1798826/4959816.aspx/1?Re+What+would+be+the+equivalent+of+this+in+VB+NET+Re: What would be the equivalent of this in VB.NET ? <p>check online tool at following link</p> <p>http://www.developerfusion.com/tools/convert/csharp-to-vb/</p> 2012-05-01T12:15:59-04:004959817http://forums.asp.net/p/1798826/4959817.aspx/1?Re+What+would+be+the+equivalent+of+this+in+VB+NET+Re: What would be the equivalent of this in VB.NET ? <p>There are a number of conversion tools available.&nbsp; Try Converter.NET it's free or other online like <a href="http://www.developerfusion.com/tools/convert/csharp-to-vb/">http://www.developerfusion.com/tools/convert/csharp-to-vb/</a>.</p> <p>In VB:</p> <pre class="prettyprint">Dim connStr2 As String = ConfigurationManager.ConnectionStrings(&quot;abc&quot;).ToString() Dim conn2 As New SqlConnection(connStr2) Dim insertValue As String = &quot;UPDATE table1 SET table1.counter = table1.counter &#43;1&quot; Dim cmd As New SqlCommand(insertValue, conn2) conn2.Open() cmd.ExecuteNonQuery() conn2.Close()</pre> <p></p> <p>HTH</p> <p>&nbsp;</p> 2012-05-01T12:16:54-04:004959820http://forums.asp.net/p/1798826/4959820.aspx/1?Re+What+would+be+the+equivalent+of+this+in+VB+NET+Re: What would be the equivalent of this in VB.NET ? <p><span color="blue" style="color:blue">Dim&nbsp;</span><span color="black" style="color:black">connStr2&nbsp;</span><span color="blue" style="color:blue">As&nbsp;String&nbsp;=&nbsp;</span><span color="black" style="color:black">ConfigurationManager.ConnectionStrings(</span><span color="#808080" style="color:#808080">&quot;abc&quot;</span><span color="black" style="color:black">).ToString()<br> </span><span color="blue" style="color:blue">Dim&nbsp;</span><span color="black" style="color:black">conn2&nbsp;</span><span color="blue" style="color:blue">As&nbsp;</span><span color="black" style="color:black">SqlConnection&nbsp;</span><span color="blue" style="color:blue">=&nbsp;New&nbsp;</span><span color="black" style="color:black">SqlConnection(connStr2)<br> </span><span color="blue" style="color:blue">Dim&nbsp;</span><span color="black" style="color:black">insertValue&nbsp;</span><span color="blue" style="color:blue">As&nbsp;String&nbsp;=&nbsp;</span><span color="#808080" style="color:#808080">&quot;UPDATE&nbsp;table1&nbsp;SET&nbsp;table1.counter&nbsp;=&nbsp;table1.counter&nbsp;&#43;1&quot;<br> </span><span color="blue" style="color:blue">Dim&nbsp;</span><span color="black" style="color:black">cmd&nbsp;</span><span color="blue" style="color:blue">As&nbsp;</span><span color="black" style="color:black">SqlCommand&nbsp;</span><span color="blue" style="color:blue">=&nbsp;New&nbsp;</span><span color="black" style="color:black">SqlCommand(insertValue,&nbsp;conn2)<br> conn2.Open()<br> cmd.ExecuteNonQuery()<br> conn2.Close()</span></p> 2012-05-01T12:17:35-04:004959824http://forums.asp.net/p/1798826/4959824.aspx/1?Re+What+would+be+the+equivalent+of+this+in+VB+NET+Re: What would be the equivalent of this in VB.NET ? <p>From <a href="http://www.developerfusion.com/tools/convert/csharp-to-vb/">http://www.developerfusion.com/tools/convert/csharp-to-vb/</a></p> <pre class="prettyprint">Dim connStr2 As String = ConfigurationManager.ConnectionStrings(&quot;abc&quot;).ToString() Dim conn2 As New SqlConnection(connStr2) Dim insertValue As String = &quot;UPDATE table1 SET table1.counter = table1.counter &#43;1&quot; Dim cmd As New SqlCommand(insertValue, conn2) conn2.Open() cmd.ExecuteNonQuery() conn2.Close()</pre> <p>&nbsp;</p> 2012-05-01T12:18:26-04:00