Problem reading an XML string without first writing to disk

[Thirsty Traveler]

I have a dataset that is returned from a sql server select that contains
metadata and a cached dataset saved in an xml column. I would like to
recover the dataset for use in generating a crystal pdf file. the
rptds.ReadXml method can accept either a string file indicating a filename
or a stream. the row["xmldata"].ToString() is the saved dataset. If I use
this directly it throws an error because it is data and not a filename. I
have a workaround seen below that first writes the xml to a temporary
diskfile and then reads it back in in the rptds.ReadXml statement. Although
this works, it is definitely kludgy... there must be a better way.

Any suggestions?

Sample Code:

public static void CreatePDF()
{
DataSet batchds = TestDAL.GetAllB atches();
foreach (DataRow row in batchds.Tables[0].Rows)
{
StreamWriter swtst = new StreamWriter(@" Test.xml", false,
Encoding.Defaul t);
swtst.Write(row["xmldata"].ToString());
swtst.Close();
DataSet rptds = new DataSet();
rptds.ReadXml(@ "Test.xml") ;
TestRpt rpt = new TestRpt ();
rpt.SetDataSour ce(rptds);
rpt.ExportToDis k(ExportFormatT ype.PortableDoc Format,
row["FileName"].ToString());
}
}

[Larry Lard]

Thirsty Traveler wrote:

I have a dataset that is returned from a sql server select that contains
metadata and a cached dataset saved in an xml column. I would like to
recover the dataset for use in generating a crystal pdf file. the
rptds.ReadXml method can accept either a string file indicating a filename
or a stream. the row["xmldata"].ToString() is the saved dataset. If I use
this directly it throws an error because it is data and not a filename. I
have a workaround seen below that first writes the xml to a temporary
diskfile and then reads it back in in the rptds.ReadXml statement. Although
this works, it is definitely kludgy... there must be a better way.

You said the answer yourself: rptds.ReadXml wants a file or a stream.
If we are not to give it a file, we must give it a stream. What kind of
stream can we make from data that is in memory already? A MemoryStream.
How do we make a MemoryStream? From an array of byte. How do we make an
array of byte from a string? With Encoding.GetByt es.

The details are left as an exercise for the reader.

Incidentally, I would be interested to know if anyone can find a method
that (unlike this one) doesn't involve using twice as much memory as
the string takes. Can we derive from Stream and create our own
StringStream, perhaps?

--
Larry Lard
Replies to group please

[sloan]

Try this post:

http://groups.google.com/group/micro...ataSet1&rnum=1

"Thirsty Traveler" <nf*@nospam.com > wrote in message
news:OT******** ******@TK2MSFTN GP05.phx.gbl...

I have a dataset that is returned from a sql server select that contains
metadata and a cached dataset saved in an xml column. I would like to
recover the dataset for use in generating a crystal pdf file. the
rptds.ReadXml method can accept either a string file indicating a filename
or a stream. the row["xmldata"].ToString() is the saved dataset. If I use
this directly it throws an error because it is data and not a filename. I
have a workaround seen below that first writes the xml to a temporary
diskfile and then reads it back in in the rptds.ReadXml statement. Although this works, it is definitely kludgy... there must be a better way.

Any suggestions?

Sample Code:

public static void CreatePDF()
{
DataSet batchds = TestDAL.GetAllB atches();
foreach (DataRow row in batchds.Tables[0].Rows)
{
StreamWriter swtst = new StreamWriter(@" Test.xml", false,
Encoding.Defaul t);
swtst.Write(row["xmldata"].ToString());
swtst.Close();
DataSet rptds = new DataSet();
rptds.ReadXml(@ "Test.xml") ;
TestRpt rpt = new TestRpt ();
rpt.SetDataSour ce(rptds);
rpt.ExportToDis k(ExportFormatT ype.PortableDoc Format,
row["FileName"].ToString());
}
}

[Thirsty Traveler]

Thanks... I was playing with MemoryStream but unable to get it to work...
Encoding.GetByt es was my missing link.

"Larry Lard" <la*******@hotm ail.com> wrote in message
news:11******** **************@ g10g2000cwb.goo glegroups.com.. .

Thirsty Traveler wrote:

I have a dataset that is returned from a sql server select that contains
metadata and a cached dataset saved in an xml column. I would like to
recover the dataset for use in generating a crystal pdf file. the
rptds.ReadXml method can accept either a string file indicating a
filename
or a stream. the row["xmldata"].ToString() is the saved dataset. If I use
this directly it throws an error because it is data and not a filename. I
have a workaround seen below that first writes the xml to a temporary
diskfile and then reads it back in in the rptds.ReadXml statement.
Although
this works, it is definitely kludgy... there must be a better way.

You said the answer yourself: rptds.ReadXml wants a file or a stream.
If we are not to give it a file, we must give it a stream. What kind of
stream can we make from data that is in memory already? A MemoryStream.
How do we make a MemoryStream? From an array of byte. How do we make an
array of byte from a string? With Encoding.GetByt es.

The details are left as an exercise for the reader.

Incidentally, I would be interested to know if anyone can find a method
that (unlike this one) doesn't involve using twice as much memory as
the string takes. Can we derive from Stream and create our own
StringStream, perhaps?

--
Larry Lard
Replies to group please

[Jon Skeet [C# MVP]]

Larry Lard <la*******@hotm ail.com> wrote:

You said the answer yourself: rptds.ReadXml wants a file or a stream.

That's not strictly true though. It wants a file, a stream, a
TextReader or an XmlReader. TextReader is what we want here -
StringReader, specifically.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too

[Thirsty Traveler]

The following code works without having to write/read from disk:

public static void CreatePDF()
{
DataSet batchds = TestDAL.GetAllB atches();

foreach (DataRow row in batchds.Tables[0].Rows)
{
DataSet rptds = new DataSet();
byte[] b = Encoding.UTF8.G etBytes(row["Data"].ToString());
MemoryStream ms = new MemoryStream(b) ;

rptds.ReadXml(m s);

TestRpt rpt = new TestRpt ();
rpt.SetDataSour ce(rptds);

rpt.ExportToDis k(ExportFormatT ype.PortableDoc Format,
row["FileName"].ToString());
}
}

"Jon Skeet [C# MVP]" <sk***@pobox.co m> wrote in message
news:MP******** *************** *@msnews.micros oft.com...

Larry Lard <la*******@hotm ail.com> wrote:

You said the answer yourself: rptds.ReadXml wants a file or a stream.

That's not strictly true though. It wants a file, a stream, a
TextReader or an XmlReader. TextReader is what we want here -
StringReader, specifically.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too

[Jon Skeet [C# MVP]]

Thirsty Traveler <nf*@nospam.com > wrote:

The following code works without having to write/read from disk:

Yes, but it does create a copy of the data. Why not use create a
StringReader, as I suggested?

StringReader reader = new StringReader(ro w["Data"].ToString());
rptds.ReadXml(r eader);

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too

[Larry Lard]

Jon wrote:

Larry Lard <la*******@hotm ail.com> wrote:

You said the answer yourself: rptds.ReadXml wants a file or a stream.

That's not strictly true though. It wants a file, a stream, a
TextReader or an XmlReader. TextReader is what we want here -
StringReader, specifically.

That's what I get for trusting the info on the support call, I suppose
:)

--
Larry Lard
Replies to group please

[Thirsty Traveler]

Awesome... this final touch rendered the solution simple and elegant.

Thanks.

"Jon Skeet [C# MVP]" <sk***@pobox.co m> wrote in message
news:MP******** *************** *@msnews.micros oft.com...

Thirsty Traveler <nf*@nospam.com > wrote:

The following code works without having to write/read from disk:

Yes, but it does create a copy of the data. Why not use create a
StringReader, as I suggested?

StringReader reader = new StringReader(ro w["Data"].ToString());
rptds.ReadXml(r eader);

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too