Question Update Database using datagridview

[confused]

I am building an application in which I am using Ms Access as the database.
Now when somebode searches the data is shown in Datagridview conrol using only dataadapter and dataset methods
Now I want that if user do the chenges in the DataGridView and then clicks on update button then data should gets updated.

But I am not finding any way to do that......


I am compeletely confused.....

Please help me out

 

[henryminute]

Try this:

    ' Save data from DataGridView into Database

    Private Sub updateButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles updateButton.Click
        Me.Validate()
        Me.myDA.Update(Me.myDataSet.Tables("MyTable"))
        Me.myDataSet.AcceptChanges()
    End Sub

Hope this helps!

 

[confused]

Thanks for the assistance man...

Work done.... So thread closed.. Thanks once again..

 

[higkiller]

Try this:

    ' Save data from DataGridView into Database

    Private Sub updateButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles updateButton.Click
        Me.Validate()
        Me.myDA.Update(Me.myDataSet.Tables("MyTable"))
        Me.myDataSet.AcceptChanges()
    End Sub

Hope this helps!

please help me guys
Me.myDA
and
Me.myDataSet

giving error helps? what else do i need to add

 

[jmcilhinney]

please help me guys
Me.myDA
and
Me.myDataSet

giving error helps? what else do i need to add

What do you think 'myDA' and 'myDataSet' represent?