Is it possible to write out just a DataRow to XML? I have a situation where I have a DataSet with a DataTable with multiple DataRows (pretty common situation, huh? :)). The DataTable has several linking/tracking fields, and a bunch of informational fields. I need to end up with a DataTable that has all the linking/tracking fields, plus just one other field to hold all the informational fields as encrypted text in a way that can easily be unencrypted and used to regenerate the original DataTable structure (or at least populate a DataRow from a DataTable of the same structure as the original DataTable). Each DataRow in the new DataTable would contain the linking/tracking data from a DataRow in the original DataTable, plus the informational data (or the whole DataRow) from the original DataRow encrypted.

I was thinking of taking each DataRow from the original DataTable and exporting it to XML and storing that in the encryted field of the new DataTable, but it seems you can only export an entire DataSet to XML, not individual DataRows. I suppose I could create a new DataSet with a new DataTable, add the DataRow, and export that whole DataSet to xml to store in the encrypted field. Doing that for each DataRow in the original DataTable sounds like quite a performance hit (although the encryption itself is a good size performance hit already).

Does anyone have any ideas or suggestions on how I can do this?

-----
Lee Perkins