Failed Update data by using a TableAdapter in .NET Framework applications

Question

Failed Update data by using a TableAdapter in .NET Framework applications

qp 26

In Visual studio 2022, I have created a VB forms connect with my table in SQL. I can add new record in table but not update. Here is the code

Private Sub ButtonUpdate_Click(sender As Object, e As EventArgs) Handles ButtonUpdate.Click 
     Try 
         Me.Validate() 
         Me.EmployeeBindingSource.EndEdit() 
         Me.EmployeeTableAdapter.Update(Me.HRDataSet.Employee) 
         MsgBox("Update successful") 
     Catch ex As Exception 
         MsgBox("Update failed") 
     End Try 
 End Sub

Jiachen Li-MSFT 34,241 Reputation points Microsoft External Staff

2024-01-11T07:44:14.5366667+00:00
Hi @qp , Please provide detailed information on exceptions.

Catch ex As DBConcurrencyException MsgBox("Concurrency violation: " & ex.Message) Catch ex As Exception MsgBox("Update failed: " & ex.Message)
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Jiachen Li-MSFT 34,241 Reputation points Microsoft External Staff

2024-01-22T10:02:22.86+00:00

May I know if you have got any chance to check my reply? It will be great if you can share more detailed information for us to better investigate this issue. Thanks for your cooperation.

1 answer

Your answer

Jiachen Li-MSFT 34,241 Reputation points Microsoft External Staff

2024-01-11T07:44:14.5366667+00:00

Hi @qp , Please provide detailed information on exceptions.

Catch ex As DBConcurrencyException MsgBox("Concurrency violation: " & ex.Message) Catch ex As Exception MsgBox("Update failed: " & ex.Message)
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Jiachen Li-MSFT 34,241 Reputation points Microsoft External Staff

2024-01-22T10:02:22.86+00:00

May I know if you have got any chance to check my reply? It will be great if you can share more detailed information for us to better investigate this issue. Thanks for your cooperation.

Answer 1

I am using the same code and am having the same problem. @Jiachen Li-MSFT I am not getting an exception. I get the msgbox "Update successful". The data table on the form shows the new data. The edited data is just not writing to the database. When I next close and then open the project the data has not been changed. Button 1 changes the data in the DataGridView. Button2 doesn't update the (Access) database.

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click

  MatchedBettingDataSet.Bets(1).Site = "New Web Site Name"

End Sub

Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click

    Try

        Me.Validate()

        Me.MatchedBettingDataSetBindingSource.EndEdit()

        Me.BetsTableAdapter.Update(Me.MatchedBettingDataSet.Bets)

        MsgBox("Update successful")

    Catch ex As Exception

        MsgBox("Update failed")

    End Try

End Sub

In the past I've done everything by SQL statements but this is the first time I've used the binding method. Any help would be appreciated.

Share via

Failed Update data by using a TableAdapter in .NET Framework applications

1 answer

Your answer