index > Windows Forms Data Controls and Databinding > DataAdapter.Update() dosen't work !

DataAdapter.Update() dosen't work !

There is a DataGridView which is bounded to the Northwind database.
I use the following procedure to save all changes that are made to DataSet, but it doesn't save new rows.

PrivateSubButton3_Click(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesbtnUpdate.Click
Try
IfmyDataSet11.HasChangesThen
Me.BindingContext(myDataSet11,"Employees").EndCurrentEdit()
SqlDataAdapter1.Update(myDataSet11)
myDataSet11.AcceptChanges()
EndIf
CatcherrObjAsException
MsgBox(errObj.Message.ToString())
myDataSet11.RejectChanges()
EndTry
EndSub

Afshin_Zavar Wednesday, February 04, 2009 2:40 PM

The code looks reasonable.
Several things you can try

a) confirm that the dataset actually has changes,
myDataSet11.HasChanges(DataRowState.Added)
b) may not have changes until after you call EndCurrentEdit to add a new row in the view to the table.
consider moving that line before the call to HasChanges.

This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to mark the replies as answers if they help.