How to parse XML out of an XMLHTTP40 object

[kfrost]

I'm connecting to an exchange public folder and pulling out contacts via XML.
I can use the .responseText to view the text string. The response from
Exchange in this string is formatted in XML. I'm trying to figure out what I
could use to parse the info out of the response because I need to write the
values to SQL.

Here's the code:

try
{
MSXML2.XMLHTTP4 0 oXMLHttp = new MSXML2.XMLHTTP4 0();

//TODO: To list items, uncomment "const bool bListItems = false;"
// const bool bListFolders = true;
const bool bListItems = false;
String sUrl;
//TODO: Replace ExchServer with your Exchange server and UserAlias with
your user alias.
sUrl= "http://cartman/public";
oXMLHttp.open(" SEARCH", sUrl, false, "n-sv\\kris", "28273De,") ;

//TODO: Use this query to list items.
String sQuery;
sQuery = "<?xml version='1.0'?> " +
"<g:searchreque st xmlns:g='DAV:'> " +
"<g:sql>SEL ECT \"DAV:displayna me\", \"DAV:creationd ate\",
\"urn:schemas:c ontacts:telepho neNumber\" " +
"FROM SCOPE('SHALLOW TRAVERSAL OF \"" + sUrl + "\"')" +
" WHERE \"DAV:isfolder\ " = " + bListItems.ToSt ring()+
"</g:sql>" +
"</g:searchrequest >";
/*
//TODO: Use this query to list folders.
String sQuery;
sQuery = "<?xml version='1.0'?> " +
"<g:searchreque st xmlns:g='DAV:'> " +
"<g:sql>SEL ECT \"DAV:displayna me\" " +
"FROM SCOPE('SHALLOW TRAVERSAL OF \"" + sUrl + "\"')" +
" WHERE \"DAV:isfolder\ " = " + bListFolders.To String() +
"</g:sql>" +
"</g:searchrequest >";
*/

oXMLHttp.setReq uestHeader("Con tent-Type", "text/xml");
oXMLHttp.setReq uestHeader("Tra nslate", "f");
oXMLHttp.setReq uestHeader("Con tent-Length", "" + sQuery.Length);
Console.WriteLi ne(sQuery);
oXMLHttp.send(s Query);

// Need to create a stream to pass to the XmlTextReader
// stream = new StringReader(oX MLHttp.response XML.ToString()) ;

// xtr = new XmlTextReader(s tream);

// xtr.WhitespaceH andling = WhitespaceHandl ing.All;

txtResults.Text = oXMLHttp.respon seText;
// if(xtr.Read())
// txtResults.Text = xtr.NodeType.To String() +
xtr.Name.ToStri ng() + xtr.Value.ToStr ing();

// probably take and return the status number to a literal
// 207 seems to indicate good possibly describe the others
Console.WriteLi ne(oXMLHttp.sta tus);
Console.WriteLi ne(oXMLHttp.sta tusText);
Console.WriteLi ne(oXMLHttp.res ponseText);

}
catch (Exception ex)
{
Console.WriteLi ne("{0} Exception caught.", ex);
}

[John Wadie]

There is a good example on searching Exchange folders on
http://msdn.microsoft.com/library/en...ching_folders_
http.asp

Take a look, and see if you still need to ask about anything.

Regards,
John Wadie