I'm trying to update a row in a SQL express database using the following code.
However I cant seem to get it to actually save the data table back to the database.
Any suggestions...Thanks.
PartRow = PartsDataSet.PartsData.FindByPartNum("PTest010")
PartRow.Qty = PartRow.Qty + 2
PartRow.AcceptChanges()
'
Try
Me.Validate()
Me.PartsDataBindingSource.EndEdit()
Me.PartsDataTableAdapter.Update(PartsDataSet.PartsData)
'MsgBox("Update successful")
Catch ex As Exception
MsgBox("Update failed")
End Try
'
Me.PartsDataTableAdapter.Fill(Me.PartsDataSet.PartsData)
Go to the complete details ...