how can I refresh a single datarow from the db?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sqldataadapter, datacolumn rowstate 1
Getting the original data in a DataRow 1
how to get the id of the inserted datarow? 3
How to get DataRow array into a DataView? 8
Getting a subset of DataRows from a DataTable 9
.NET 1.1 "System.Data.VersionNotFoundException" - I need a workaro 5
SqlDataAdapter.Fill and DataRow.RowSate 1
ReadXML Dataset - Original Rows, RowState = Added (not Unchanged) 1

Top