title: Conversion from string "INSERT INTO Products_Archive VAL" to type 'Double' is not valid
body: <p>this is my sql command:</p>
  
  <pre class="lang-vb prettyprint-override"><code> sqlcom1 = New SqlCommand("INSERT INTO Products_Archive VALUES ('" + arno1 + "','" +
      ds.Tables("Products").Rows(myval).Item(0) + "','" + 
      ds.Tables("Products").Rows(myval).Item(1) + "','" + 
      ds.Tables("Products").Rows(myval).Item(2) + "','" + 
      ds.Tables("Products").Rows(myval).Item(3) + "','" + 
      ds.Tables("Products").Rows(myval).Item(4) + "','" + 
      ds.Tables("Products").Rows(myval).Item(5) + "'," + 
      ds.Tables("Products_Archive").Rows(myval).Item(6) + "," + 
      ds.Tables("Products_Archive").Rows(myval).Item(7) + ",'" + 
      ds.Tables("Products").Rows(myval).Item(8) + ",'" + 
      ds.Tables("Products").Rows(myval).Item(9) + "'," + 
      ds.Tables("Products").Rows(myval).Item(10) + "," + 
      ds.Tables("Products").Rows(myval).Item(11) + "," + 
      ds.Tables("Products").Rows(myval).Item(12) + "," + 
      ds.Tables("Products").Rows(myval).Item(13) + "," + 
      ds.Tables("Products").Rows(myval).Item(14) + ")", con1)
  
   sqlcom1.ExecuteNonQuery()
  </code></pre>
  
  <p>The columns for datasets 6,7,8,10,11,12,13,and 14 have datatype <code>bigint</code>.
  However, I always get this error </p>
  
  <pre class="lang-none prettyprint-override"><code>Conversion from string "INSERT INTO Products_Archive VAL" to type 'Double' is not valid.
  </code></pre>
  
  <p>By the way, I use sql server and vb.net</p>