I cannot get my bound datagrid to update once I have updated
the datagrid and clicked a save button. Here is my code, someone please help.


Private Sub adminForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

AdjustStockDtgLoad()

End Sub



Private Sub AdjustStockDtgLoad()

Dim sqlQuery As String = "select * from stockLevels"
stockLevelsDataSet.Clear()
adminDataAdapter.SelectCommand.CommandText = sqlQuery
adminDataAdapter.Fill(stockLevelsDataSet, "stockLevels")

Dim dataTable As DataTable = stockLevelsDataSet.Tables(0)

dtgAdjStockLevel.SetDataBinding(stockLevelsDataSet, "stockLevels")

End Sub




Private Sub cmdAdjSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdAdjSave.Click
Try

adminDataAdapter.Update(stockLevelsDataSet, "stockLevels")

dtgAdjStockLevel.Enabled = False
Catch ex As System.Data.OleDb.OleDbException

MsgBox(ex.ToString())

End Try
End Sub