Click here to Skip to main content
15,938,122 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have an application in VB .Net that connects to a database MS SQL. It is connected to a datagridview, the problem is when I add a new record when I update the dataset it accepts the 2 first cell values but the third cell becomes blank, if I click another row it exits rdit mode and accept all cell values if I press the update button.
here is the source
Private Sub SaveToolStripButton_Click(sender As Object, e As EventArgs) Handles SaveToolStripButton.Click

      If DataSet11.HasChanges Then
              SqlDataAdapter1.Update(DataSet11, "Table_1")
          Catch eUpdate As System.Exception

              'Throw eUpdate
          End Try
      End If
  End Sub

Ant ideas?

What I have tried:

I have tried this in first line
Me.BindingContext(DataSet11, "Table_1").EndCurrentEdit()

but the same behavior seems that the code cannot stop the edit mode.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900