Delete row from database using OleDb

[maylortaylor]

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.

Can anyone help me with deleting the row from the DB using OleDb?

Function DeleteTableRow()
        Dim TaxConnStr As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & 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 =" & selectedRow
            If dbConnection.State = ConnectionState.Closed Then
                dbConnection.Open()
            End If
 
            dbCommand.Connection = dbConnection
            rdr2 = dbCommand.ExecuteReader
            dbCommand.ExecuteNonQuery()
 
 
            rdr2.Close()
 
                       '''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

[Rabbit]

Your database table has a field called RowID that is populated the same way as the DataGridView?

[maylortaylor]

Well the row in the database is called "ID" and that particular row on the DataGridView is set to hidden.

[Rabbit]

The row? You mean the field in the table in the database? If it's named ID, then you need to use ID in your SQL, not RowID.

[pringstonmali]

check this datagridview tutorial

http://csharp.net-informations.com/d...w-tutorial.htm

pringston