How do you update a database from a DataView?

I have a dataGrid which is editable, and it's data is based on a dataView. After a user edits a row, and clicks the update button, what is the preferred method for updating the original database using ADO.net?

When my datasource is a dataset, I usually do

da.Update(ds.Tables(0).Select(Nothing, Nothing, DataViewRowState.ModifiedCurrent))

But this doesn't seem to be working for me.

Thanks.

Aaron

I feel that in this scenario you can use DataView.GetChanges that returns a DataTable and using this you can update the Modified records.

My preferred method is to hit the database with the necessary update query for the data in question (the single row). Build an update query and call the database with it.

-Peter

Hi guys,

Thanks for the suggestions.

Sriram: GetChanges is not actually a member of the DataView class.

planoie: This is a great suggestion, and I will actually do it this way for now, but I would love to know why the DataTable underlying my DataView is not seeing the changes I have made to the data in the DataView. Or perhaps my update statement is off.

Here is my full code to update the dataset"

        cnxn.Open()
        Dim cmd As New SqlCommand("SELECT * From ArchiveItems", cnxn)
        Dim da As New SqlDataAdapter
        da.SelectCommand = cmd
        Dim cb As SqlCommandBuilder = New SqlCommandBuilder(da)
            da.Update(ds.Tables("ArchiveItems").Select(Nothing , Nothing, DataViewRowState.ModifiedCurrent))

Reloading the data never shows any of the edits made in the dataView. I think it's a problem with that DataViewRowState property. I've tried it with ModifiedOriginal and CurrentRows as well.

Hope you can help. Thanks.

Aaron

you can update dataview like this also :

http://vb.net-informations.com/datav...iew-update.htm

thanks.