>Paul... you said Cursor, do you mean datatable?
Yeah, both of them are datatable (I was justing using two different terms to help differenciate between them in my post).
I think I've got this resolved, but if there is a built-in way I'd love to hear it. I'm essentially just iterating through the columns of the SQL DataTable and grabbing the column name, then checking to see if there is a matching column in my XML DataTable. If there is, I copy the value over.
I'm also not entirely sure why SetModified() is required - I would have expected this to get set as soon as I modified the value.
drMatch[0].SetModified();
foreach (DataColumn column in dtPortal.Columns)
{
DataColumn xmlColumn = dt.Columns[column.ColumnName];
if (xmlColumn != null)
{
drMatch[0][column.Ordinal] = row[xmlColumn.Ordinal];
}
}