Update database help [modified]

[eric_tran]

Good day everyone, I need to update a record into the database Access via table adapter in VB.Net 2005. The dataset is updated, but the record in the database Access is not. Could anyone know how to fix this problem? Please help.I'd appreciate it so much. Thanks (Student_Details:table name)

MyDataSet.Student_Details.Rows(2).Item(3) = "new password"
MyDataSet.GetChanges(DataRowState.Modified)
Student_DetailsTableAdapter1.Update(MyDataSet)
MyDataSet.AcceptChanges()

                Me.Validate()
                Me.Student\_DetailsBindingSource.EndEdit()
                Me.Student\_DetailsTableAdapter1.Update(Me.MyDataSet.Student\_Details)

-- modified at 11:11 Saturday 14th October, 2006

eric