title: insert the value of the checked ccheckbox in mysql vb.net
body: <p>how to get the value of the checked check box in data grid view and insert the selected row in database mysql.</p>
  
  <p>i have the column names cloth_id, cloth_desc quantity and price
  if the check box in the row was checked then the quantity and price will be multiplied to get the total amount to be paid. thanks in advance :)
  This code is good for only 1 row. help me in query when multiple row was checked.
  thanks :)</p>
  
  <pre><code> If e.RowIndex &gt;= 0 Then
      Dim row As DataGridViewRow
      Dim amount, qty, prod As Double
      row = Me.DataGridView1.Rows(e.RowIndex)
      amount = row.Cells("Price").Value.ToString
      qty = row.Cells("Qty").Value.ToString
      prod = amount * qty
      kg.Text = prod
  End If
  </code></pre>