Reading a Dataset from an XML file - want a fileless solution

[Brian Parker]

Here's a snippet of code I have:
=============== =============== =============== =
DataSet ds = new DataSet();

string strXMLFileName = Path.GetTempFil eName();

StreamWriter sw = File.AppendText ( strXMLFileName );
sw.WriteLine(@" <?xml version='1.0'?> ");
sw.WriteLine(@" <Results>");

ServiceReply SearchResultDat a = CategoryWebServ ice.EndRetrieve StateData(
iaCategoryHandl e );
sw.WriteLine( SearchResultDat a.CategoryXML[ 0 ] );

sw.WriteLine(@" </Results>");
sw.Close();

ds.ReadXml( strXMLFileName );
=============== =============== =============== =

"SearchResultDa ta.CategoryXML[ 0 ]" is some XML returned from a web
service. I want to take this XML, prepend it with the 2 lines and
append the last line and then convert it into a dataaset object. But, I
don't want to use a file if possible.

How can get I accomplish what is being done above without the use of the
file?

-BEP

[Zark3]

What you might try is to deserialize your
SearchResultDat a.CategoryXML[0] back into an object and adding it (and
any successive search results if needed) to a collection object/an
array used to feed the dataset (be it one-at-a-time or after
re-serializing the collection to XML)

HTH,
Chris

[Peter Bromberg [C# MVP]]

DataSet ds = new DataSet();
StringBuilder sb = new StringBuilder() ;
sb.Append(@"<?x ml version='1.0'?> ");
sb.Append(@"<Re sults>");
ServiceReply SearchResultDat a = CategoryWebServ ice.EndRetrieve StateData(
iaCategoryHandl e );
sb.Append( SearchResultDat a.CategoryXML[ 0 ] );
sb.Append(@"</Results>");
byte[] b = System.Text.Enc oding.UTF8.GetB ytes(sb.ToStrin g());
MemoryStream ms = new MemoryStream(b) ;
ds.ReadXml( ms);
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Brian Parker" wrote:

Here's a snippet of code I have:
=============== =============== =============== =
DataSet ds = new DataSet();

string strXMLFileName = Path.GetTempFil eName();

StreamWriter sw = File.AppendText ( strXMLFileName );
sw.WriteLine(@" <?xml version='1.0'?> ");
sw.WriteLine(@" <Results>");

ServiceReply SearchResultDat a = CategoryWebServ ice.EndRetrieve StateData(
iaCategoryHandl e );
sw.WriteLine( SearchResultDat a.CategoryXML[ 0 ] );

sw.WriteLine(@" </Results>");
sw.Close();

ds.ReadXml( strXMLFileName );
=============== =============== =============== =

"SearchResultDa ta.CategoryXML[ 0 ]" is some XML returned from a web
service. I want to take this XML, prepend it with the 2 lines and
append the last line and then convert it into a dataaset object. But, I
don't want to use a file if possible.

How can get I accomplish what is being done above without the use of the
file?

-BEP

[sloan]

I don't know if this helps or not.

C#


private DataSet GetDataSet1()
{
DataSet ds = new DataSet();
System.Text.Str ingBuilder sb = new System.Text.Str ingBuilder();
sb.Append("<?xm l version=\"1.0\" ?><items>");
sb.Append("<ite m>");
sb.Append("<key >abc</key>");
sb.Append("<val ue>Apple Berry Cat</value>");
sb.Append("<tim e>" + DateTime.Now.To LongTimeString( ) + "</time>");
sb.Append("</item>");
sb.Append("<ite m>");
sb.Append("<key >def</key>");
sb.Append("<val ue>Dough Elephant Fence</value>");
sb.Append("<tim e>" + DateTime.Now.To LongTimeString( ) + "</time>");
sb.Append("</item>");
sb.Append("<ite m>");
sb.Append("<key >hij</key>");
sb.Append("<val ue>House Igloo Jumprope</value>");
sb.Append("<tim e>" + DateTime.Now.To LongTimeString( ) + "</time>");
sb.Append("</item>");
sb.Append("</items>");
System.IO.Memor yStream ms = new System.IO.Memor yStream();
System.IO.Strea mWriter writer = new System.IO.Strea mWriter(ms);
writer.Write(sb .ToString());
writer.Flush();
ms.Position = 0;
ds.ReadXml(ms);
return ds;
}

VB.NET
Private Function GetDataSet1() As DataSet
Dim ds As New DataSet

Dim sb As New System.Text.Str ingBuilder
sb.Append("<?xm l version=""1.0"" ?><items>")

sb.Append("<ite mid>20002</itemid>")
sb.Append("<fri endlyname1>Maci ntosh</friendlyname1>" )
sb.Append("<fri endlyname2>MA</friendlyname2>" )
sb.Append(("<ti me>" + DateTime.Now.To LongTimeString( ) + "</time>"))
sb.Append("<par entid>2001</parentid>")
sb.Append("</item>")

sb.Append("</items>")

Dim ms As New System.IO.Memor yStream
Dim writer As New System.IO.Strea mWriter(ms)
writer.Write(sb .ToString())
writer.Flush()
ms.Position = 0
ds.ReadXml(ms)
Return ds
End Function 'GetDataSet1
"Brian Parker" <be******@yahoo .com> wrote in message
news:WoL3g.4056 $B42.902@dukere ad05...

Here's a snippet of code I have:
=============== =============== =============== =
DataSet ds = new DataSet();

string strXMLFileName = Path.GetTempFil eName();

StreamWriter sw = File.AppendText ( strXMLFileName );
sw.WriteLine(@" <?xml version='1.0'?> ");
sw.WriteLine(@" <Results>");

ServiceReply SearchResultDat a = CategoryWebServ ice.EndRetrieve StateData(
iaCategoryHandl e );
sw.WriteLine( SearchResultDat a.CategoryXML[ 0 ] );

sw.WriteLine(@" </Results>");
sw.Close();

ds.ReadXml( strXMLFileName );
=============== =============== =============== =

"SearchResultDa ta.CategoryXML[ 0 ]" is some XML returned from a web
service. I want to take this XML, prepend it with the 2 lines and
append the last line and then convert it into a dataaset object. But, I
don't want to use a file if possible.

How can get I accomplish what is being done above without the use of the
file?

-BEP

[Brian Parker]

sloan wrote:

I don't know if this helps or not.
private DataSet GetDataSet1()
{
DataSet ds = new DataSet();
System.Text.Str ingBuilder sb = new System.Text.Str ingBuilder();
sb.Append("<?xm l version=\"1.0\" ?><items>"); ** STUFF SNIPPED ** sb.Append("</items>");
System.IO.Memor yStream ms = new System.IO.Memor yStream();
System.IO.Strea mWriter writer = new System.IO.Strea mWriter(ms);
writer.Write(sb .ToString());
writer.Flush();
ms.Position = 0;
ds.ReadXml(ms);
return ds;
}

I think that's exactly what I need.
Thanks,
-BEP