Reading XML stored as Blob into Dataset

  • Thread starter Thread starter Spike
  • Start date Start date
S

Spike

Hi all,
Ive been successful in trying to read a blob XML (XML
is stored as blob in database) into a Dataset. However the
process seems to be very slow. Ive used the following
method.

Fetch data into a DataTable
Read the blob column into a byte array
Write byte Array to String
Read the String into StringReader
Use DataSet.ReadXML to read from the StringReader

Can anyone give some better options to speed up the
process.

Thanks in Advance
Spike.
 
Back
Top