title: how to update column in database MySQL
body: <p>I am trying to update my database column, using data from datagridview column. I am using MySQL for database and vb.net for program.</p>
  
  <p>This is my code:</p>
  
  <pre><code>cmd = New MySqlCommand("UPDATE tb_poinjalan 
        SET Bobot ='" &amp; DataGridView2.Item(4, i).Value 
        &amp; "' WHERE Kriteria='" &amp; DataGridView2.Item(1, i).Value 
        &amp; "';", Connector)
  </code></pre>
  
  <p>The problem is, this code only change first row in database column.</p>