Updating Data in a DataView

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hi Guys,

I have a situation where I have a grid loaded with data. It is not data
bound. Clicking an image opens up another form that allows the change of
the data in the grid.

Right now the changed data (1 row) is written to the DB and the whole
grid is reloaded from the DB which now incorporates the change.

My question is can I update the data in a data view? That way I can
right the change to the DB and update the DataView without having to dip
the DB every time and essentially avoid reloading a 1000 rows of data
because I changed one.

How do I change one row in a DataView?

Thanks

Tim
 
You can use the GetChanges method to create a new DataSet that can be sent
into a DataAdapter to perform your update on only the changed rows. Since
you've already made the change to the original dataset, you don't need to
return everything back from the database. This of course doesn't take into
account concurrency issues, but it may be sufficient for your issue.

Peter
 
Back
Top