Read XML from string instead of file (C#)

[th3dude]

I've searched quite a bit for this one and i can't find any solid
solution for what i'm doing here.

Right now i'm geting an xml string from an API, creating an xml file,
then read the file with XPath or XmlReader, grab the attribute data,
dump it into the database.
Once all that's done i blow away all the xml files and start the whole
process over next time i need to read fresh data from the API.
Question is, how can i just read the returned xml string from the API
and parse out all my data without having to deal with creating,
reading, dumping all these files.
Should be doable i think...
I know this is probably kind of a noob question, but i'm no xml guru,
obviously...
Thanks for any info...

[PeterKellner]

On 1 Jun 2006 21:40:43 -0700, "th3dude" <gn*****@gmail. com> wrote:

Question is, how can i just read the returned xml string from the API
and parse out all my data without having to deal with creating,
reading, dumping all these files.

You need to create a MemoryStream out of it. The example I'm pasting
below I created a DOM out of the XML but I think you can morph it into
what you want.

public static List<Membership ProfileInfo>
CheckXMLForProf ileData(string xmlData,string userName,out
string errorString)
{
// take in this xml and look for profile data
// <profile defaultProvider ="SqlProfilePro vider">
// <providers>
// <remove name="AspNetSql ProfileProvider "/>
// <add name="SqlProfil eProvider"
type="System.We b.Profile.SqlPr ofileProvider"
// connectionStrin gName="LocalSql Server"/>
// </providers>
// <properties>
// <add name="advancedM ode" type="bool"/>
// <add name="defaultCo nnectionName"
type="string"/>
// <add name="defaultNa meSpaceGenerate d"
type="string"/>
// <add name="debugMode " type="bool"/>
// <add name="FirstName " type="string"/>
// <add name="LastName" type="string"/>
// <add name="City" type="string"/>
// <add name="State" type="string"/>
// <add name="Country" type="string"/>
// <add name="Company" type="string"/>
// </properties>
//</profile>

errorString = string.Empty;
byte[] byteArray = new byte[xmlData.Length];
System.Text.ASC IIEncoding encoding = new
System.Text.ASC IIEncoding();
byteArray = encoding.GetByt es(xmlData);

// Load the memory stream
MemoryStream memoryStream = new MemoryStream(by teArray);
//XmlDocument doc = new XmlDocument();
memoryStream.Se ek(0, SeekOrigin.Begi n);

List<Membership ProfileInfo> mpiLi = new
List<Membership ProfileInfo>();

if (byteArray.Leng th > 0)
{
try
{
XmlDocument doc = new XmlDocument();
doc.Load(memory Stream);

string xPath1 = "/system.web/profile/properties";
XmlNodeList nodeList = doc.SelectNodes (xPath1);

foreach (XmlNode nodex in nodeList)
{
if (nodex.HasChild Nodes)
{
foreach (XmlNode nodexx in
nodex.ChildNode s)
{
if (nodexx.Name.Eq uals("group"))
{
// Get Group Name
MembershipProfi leInfo mpi = new
MembershipProfi leInfo();
mpi = GetAttrs(nodexx ,
string.Empty);
string prefixName = mpi.Name;
foreach (XmlNode nodexxx in
nodexx.ChildNod es)
{
MembershipProfi leInfo mpi1 =
new MembershipProfi leInfo();
mpi1 = GetAttrs(nodexx x,
prefixName);
mpiLi.Add(mpi1) ;
}
}
else if (nodexx.Name.Eq uals("add"))
{
MembershipProfi leInfo mpi = new
MembershipProfi leInfo();
mpi = GetAttrs(nodexx ,
string.Empty);
mpiLi.Add(mpi);
}
}
}
}
}
catch (Exception eee)
{
errorString = eee.ToString();
}
}
return mpiLi;
}
Peter Kellner
http://peterkellner.net

[th3dude]

Peter,

Thanks for the reply, i'll give this a shot and see if i can get it to
work.

Cheers.

PeterKellner wrote:

On 1 Jun 2006 21:40:43 -0700, "th3dude" <gn*****@gmail. com> wrote:

Question is, how can i just read the returned xml string from the API
and parse out all my data without having to deal with creating,
reading, dumping all these files.

You need to create a MemoryStream out of it. The example I'm pasting
below I created a DOM out of the XML but I think you can morph it into
what you want.

public static List<Membership ProfileInfo>
CheckXMLForProf ileData(string xmlData,string userName,out
string errorString)
{
// take in this xml and look for profile data
// <profile defaultProvider ="SqlProfilePro vider">
// <providers>
// <remove name="AspNetSql ProfileProvider "/>
// <add name="SqlProfil eProvider"
type="System.We b.Profile.SqlPr ofileProvider"
// connectionStrin gName="LocalSql Server"/>
// </providers>
// <properties>
// <add name="advancedM ode" type="bool"/>
// <add name="defaultCo nnectionName"
type="string"/>
// <add name="defaultNa meSpaceGenerate d"
type="string"/>
// <add name="debugMode " type="bool"/>
// <add name="FirstName " type="string"/>
// <add name="LastName" type="string"/>
// <add name="City" type="string"/>
// <add name="State" type="string"/>
// <add name="Country" type="string"/>
// <add name="Company" type="string"/>
// </properties>
//</profile>

errorString = string.Empty;
byte[] byteArray = new byte[xmlData.Length];
System.Text.ASC IIEncoding encoding = new
System.Text.ASC IIEncoding();
byteArray = encoding.GetByt es(xmlData);

// Load the memory stream
MemoryStream memoryStream = new MemoryStream(by teArray);
//XmlDocument doc = new XmlDocument();
memoryStream.Se ek(0, SeekOrigin.Begi n);

List<Membership ProfileInfo> mpiLi = new
List<Membership ProfileInfo>();

if (byteArray.Leng th > 0)
{
try
{
XmlDocument doc = new XmlDocument();
doc.Load(memory Stream);

string xPath1 = "/system.web/profile/properties";
XmlNodeList nodeList = doc.SelectNodes (xPath1);

foreach (XmlNode nodex in nodeList)
{
if (nodex.HasChild Nodes)
{
foreach (XmlNode nodexx in
nodex.ChildNode s)
{
if (nodexx.Name.Eq uals("group"))
{
// Get Group Name
MembershipProfi leInfo mpi = new
MembershipProfi leInfo();
mpi = GetAttrs(nodexx ,
string.Empty);
string prefixName = mpi.Name;
foreach (XmlNode nodexxx in
nodexx.ChildNod es)
{
MembershipProfi leInfo mpi1 =
new MembershipProfi leInfo();
mpi1 = GetAttrs(nodexx x,
prefixName);
mpiLi.Add(mpi1) ;
}
}
else if (nodexx.Name.Eq uals("add"))
{
MembershipProfi leInfo mpi = new
MembershipProfi leInfo();
mpi = GetAttrs(nodexx ,
string.Empty);
mpiLi.Add(mpi);
}
}
}
}
}
catch (Exception eee)
{
errorString = eee.ToString();
}
}
return mpiLi;
}
Peter Kellner
http://peterkellner.net

[th3dude]

Peter,

I ended up doing something very similar to this, but i was able to get
it to work using jsut a string and not creating the memory stream.

Your post did point me in the right direction though so thanks again!
th3dude wrote:

Peter,

Thanks for the reply, i'll give this a shot and see if i can get it to
work.

Cheers.

PeterKellner wrote:

On 1 Jun 2006 21:40:43 -0700, "th3dude" <gn*****@gmail. com> wrote:

Question is, how can i just read the returned xml string from the API
and parse out all my data without having to deal with creating,
reading, dumping all these files.

You need to create a MemoryStream out of it. The example I'm pasting
below I created a DOM out of the XML but I think you can morph it into
what you want.

public static List<Membership ProfileInfo>
CheckXMLForProf ileData(string xmlData,string userName,out
string errorString)
{
// take in this xml and look for profile data
// <profile defaultProvider ="SqlProfilePro vider">
// <providers>
// <remove name="AspNetSql ProfileProvider "/>
// <add name="SqlProfil eProvider"
type="System.We b.Profile.SqlPr ofileProvider"
// connectionStrin gName="LocalSql Server"/>
// </providers>
// <properties>
// <add name="advancedM ode" type="bool"/>
// <add name="defaultCo nnectionName"
type="string"/>
// <add name="defaultNa meSpaceGenerate d"
type="string"/>
// <add name="debugMode " type="bool"/>
// <add name="FirstName " type="string"/>
// <add name="LastName" type="string"/>
// <add name="City" type="string"/>
// <add name="State" type="string"/>
// <add name="Country" type="string"/>
// <add name="Company" type="string"/>
// </properties>
//</profile>

errorString = string.Empty;
byte[] byteArray = new byte[xmlData.Length];
System.Text.ASC IIEncoding encoding = new
System.Text.ASC IIEncoding();
byteArray = encoding.GetByt es(xmlData);

// Load the memory stream
MemoryStream memoryStream = new MemoryStream(by teArray);
//XmlDocument doc = new XmlDocument();
memoryStream.Se ek(0, SeekOrigin.Begi n);

List<Membership ProfileInfo> mpiLi = new
List<Membership ProfileInfo>();

if (byteArray.Leng th > 0)
{
try
{
XmlDocument doc = new XmlDocument();
doc.Load(memory Stream);

string xPath1 = "/system.web/profile/properties";
XmlNodeList nodeList = doc.SelectNodes (xPath1);

foreach (XmlNode nodex in nodeList)
{
if (nodex.HasChild Nodes)
{
foreach (XmlNode nodexx in
nodex.ChildNode s)
{
if (nodexx.Name.Eq uals("group"))
{
// Get Group Name
MembershipProfi leInfo mpi = new
MembershipProfi leInfo();
mpi = GetAttrs(nodexx ,
string.Empty);
string prefixName = mpi.Name;
foreach (XmlNode nodexxx in
nodexx.ChildNod es)
{
MembershipProfi leInfo mpi1 =
new MembershipProfi leInfo();
mpi1 = GetAttrs(nodexx x,
prefixName);
mpiLi.Add(mpi1) ;
}
}
else if (nodexx.Name.Eq uals("add"))
{
MembershipProfi leInfo mpi = new
MembershipProfi leInfo();
mpi = GetAttrs(nodexx ,
string.Empty);
mpiLi.Add(mpi);
}
}
}
}
}
catch (Exception eee)
{
errorString = eee.ToString();
}
}
return mpiLi;
}
Peter Kellner
http://peterkellner.net

[Remy]

Not sure if I'm missing something, but I just used a StringReader:

string xml = null;

//load the xml into the string, etc. etc.

XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(new StringReader(xm l));

Cheers

Remy

[th3dude]

Well my original issue was happening because of some odd Xpath
behavior, so when i
changed to XmlNodeList/XmlElement and dumped Xpath everything worked
much better fof this particular application...

And yes the following works well for me now...

XmlDocument doc = new XmlDocument();
doc.LoadXml(xml string);

Thanks,
--gary

Remy wrote:

Not sure if I'm missing something, but I just used a StringReader:

string xml = null;

//load the xml into the string, etc. etc.

XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(new StringReader(xm l));

Cheers

Remy