how can I refresh a single datarow from the db?

  • Thread starter Thread starter David Burson
  • Start date Start date
D

David Burson

Hi,

I have a datatable, loaded using a dataadapter.fill. I
need to refresh a single datarow from the database. I
have other datarows that have been modified, but not
saved to the database yet.

Currently, when I want to refresh a single row, I set the
dataadapter.SelectCommand so I only get the row I want
from the database. However, when I call
dataadapter.fill, my modified datarows are reset to their
original values and the rowstate is set to Unchanged.

How can I refresh a single datarow from the database
without affecting the rowstate and values of the other
datarows in the datatable?

Thanks,
David
 
Back
Top