title: Delete row from database using OleDb
body: <p>I have this function working half right. The part that is working right is where I can select a row on the DataGridView, call this function using a "Delete Row" button, and then it will delete the row from the DataGridView....However, it does not delete the row on the database. </p>
  
  <p>Can anyone help me with deleting the row from the DB using OleDb?</p>
  
  <pre><code>Function DeleteTableRow()
      Dim TaxConnStr As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" &amp; ConfigurationManager.AppSettings("Database")
      Dim dbConnection = New OleDbConnection(TaxConnStr)
  
      Try
          Dim dbCommand As OleDbCommand = New OleDbCommand
          Dim rdr2 As OleDbDataReader
  
          Dim selectedRow = DataGridView1.SelectedRows
  
          dbCommand.CommandText = "DELETE FROM UserCriteria WHERE RowID =" &amp; selectedRow
          If dbConnection.State = ConnectionState.Closed Then
              dbConnection.Open()
          End If
  
          dbCommand.Connection = dbConnection
          rdr2 = dbCommand.ExecuteReader
          dbCommand.ExecuteNonQuery()
  
  
          rdr2.Close()
  
          '''Must select entire row to delete
          'DataGridView1.Rows.Remove(DataGridView1.Rows(DataGridView1.SelectedCells.Item(0).RowIndex))
  
          '''allows you to select on cell in the row to delete entire row
          For Each oneCell As DataGridViewCell In DataGridView1.SelectedCells
              If oneCell.Selected Then
                  DataGridView1.Rows.RemoveAt(oneCell.RowIndex)
              End If
          Next
  
  
  
      Catch ex As Exception
          MsgBox(ex.Message)
      Finally
          dbConnection.Close()
      End Try
  End Function
  </code></pre>