Delete Button Not Working

[rashaadbryan246]

hi so i have a basic form connected to a database to connect to a database, now my problem is that when i press delete it deletes from the datagridview but not from the actual database and yes i am checking the database in the debug folder also after I use the delete button when add a new row to the database and click save the program crashes and i get the error Concurrency violation: the DeleteCommand affected 0 of the expected 1 records

Save button code

[TD="class: number"]01[/TD]
[TD="class: content"]Private Sub btnSave_Click_1(sender As Object, e As EventArgs) Handles btnSave.Click[/TD]

[TD="class: number"]02[/TD]
[TD="class: content"][/TD]

[TD="class: number"]03[/TD]
[TD="class: content"] Try[/TD]

[TD="class: number"]04[/TD]
[TD="class: content"] Me.Validate()[/TD]

[TD="class: number"]05[/TD]
[TD="class: content"] Me.InterimStorageOrdersBindingSource.EndEdit()[/TD]

[TD="class: number"]06[/TD]
[TD="class: content"] Me.Interim_Storage_OrdersTableAdapter.Update(Me.Stock_ManagerDataSet.Interim_Storage_Orders)[/TD]

[TD="class: number"]07[/TD]
[TD="class: content"] MsgBox("Update successful")[/TD]

[TD="class: number"]08[/TD]
[TD="class: content"][/TD]

[TD="class: number"]09[/TD]
[TD="class: content"] Catch ex As Exception[/TD]

[TD="class: number"]10[/TD]
[TD="class: content"] MsgBox("Update failed")[/TD]

[TD="class: number"]11[/TD]
[TD="class: content"] End Try[/TD]

[TD="class: number"]12[/TD]
[TD="class: content"][/TD]

[TD="class: number"]13[/TD]
[TD="class: content"] End Sub[/TD]

Delete Button Code

[TD="class: number"]1[/TD]
[TD="class: content"]Private Sub btnDelete_Click(sender As Object, e As EventArgs) Handles btnDelete.Click[/TD]

[TD="class: number"]2[/TD]
[TD="class: content"] InterimStorageOrdersBindingSource.RemoveCurrent()[/TD]

[TD="class: number"]3[/TD]
[TD="class: content"] End Sub[/TD]

 

[jmcilhinney]

You have successfully made your code difficult to read. Please post code snippets using code formatting tags, i.e.

[xcode=vb]your code here[/xcode]

or, if you need the option for custom formatting:

[code]your code here[/code]

 

[jmcilhinney]

You have a Save method that you presumably use to save inserts and updates back to the database. You have to save deletes in exactly the same way. Calling Update on your table adapter saves all the changes from the DataTable back to the database, which includes inserts, updates and deletes. Just as an insert or update only affects the local DataTable until you explicitly save that change back to the database, so does a delete.

 

[JuggaloBrotha]

hi so i have a basic form connected to a database to connect to a database, now my problem is that when i press delete it deletes from the datagridview but not from the actual database and yes i am checking the database in the debug folder also after I use the delete button when add a new row to the database and click save the program crashes and i get the error Concurrency violation: the DeleteCommand affected 0 of the expected 1 records

Save button code

[TD="class: number"]01[/TD]
[TD="class: content"]Private Sub btnSave_Click_1(sender As Object, e As EventArgs) Handles btnSave.Click[/TD]

[TD="class: number"]02[/TD]
[TD="class: content"][/TD]

[TD="class: number"]03[/TD]
[TD="class: content"] Try[/TD]

[TD="class: number"]04[/TD]
[TD="class: content"] Me.Validate()[/TD]

[TD="class: number"]05[/TD]
[TD="class: content"] Me.InterimStorageOrdersBindingSource.EndEdit()[/TD]

[TD="class: number"]06[/TD]
[TD="class: content"] Me.Interim_Storage_OrdersTableAdapter.Update(Me.Stock_ManagerDataSet.Interim_Storage_Orders)[/TD]

[TD="class: number"]07[/TD]
[TD="class: content"] MsgBox("Update successful")[/TD]

[TD="class: number"]08[/TD]
[TD="class: content"][/TD]

[TD="class: number"]09[/TD]
[TD="class: content"] Catch ex As Exception[/TD]

[TD="class: number"]10[/TD]
[TD="class: content"] MsgBox("Update failed")[/TD]

[TD="class: number"]11[/TD]
[TD="class: content"] End Try[/TD]

[TD="class: number"]12[/TD]
[TD="class: content"][/TD]

[TD="class: number"]13[/TD]
[TD="class: content"] End Sub[/TD]

Delete Button Code

[TD="class: number"]1[/TD]
[TD="class: content"]Private Sub btnDelete_Click(sender As Object, e As EventArgs) Handles btnDelete.Click[/TD]

[TD="class: number"]2[/TD]
[TD="class: content"] InterimStorageOrdersBindingSource.RemoveCurrent()[/TD]

[TD="class: number"]3[/TD]
[TD="class: content"] End Sub[/TD]

Holy crap that's impossible to read, try using the [xcode=vb]Your code here[/xcode] tags so we can read it, it'll make your code look like this:

Private Sub btnSave_Click_1(sender As Object, e As EventArgs) Handles btnSave.Click
    Try
    Catch ex As Exception
    End Try
End Sub