How do I populate a DataSet from a SQL Server 2005 xml datatype

  • Thread starter Thread starter Thirsty Traveler
  • Start date Start date
T

Thirsty Traveler

I have an xml column in a SQL Server 2005 table that was populated with a
DataSet. I would like to read that column back into a DataSet object but am
not quire sure how.

Any ideas?
 
you would need to bring back this column value as an XML String and then do
DataSet.ReadXml(theString) on it.
Peter
 
What is an xml string? Is this a type?

What is returned to me from a stored procedure call is a DataSet with
several columns of metadata that also includes the xml dataset column
associated with the metadata. I need to attach the dataset column to a
crystal report as a datasource and do other things with the metadata (such
as the file server/folder destination of the pdf created by the crystal
report component) but am not sure how to do this.
 
Back
Top