Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
All-Star
118619 Points
18779 Posts
Nov 12, 2011 12:39 AM|LINK
Hello maduragnga001:)
You can in fact also use XDocument to deal with your prblem like this by looping the element layer by layer:
public static DataTable GetTickets() { HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(_myDomain + "/rules/651263.xml"); request.Method = "GET"; request.Credentials = new NetworkCredential(_Username, _Password); request.ContentLength = 0; HttpWebResponse resp = (HttpWebResponse)request.GetResponse(); StreamReader reader = new StreamReader(resp.GetResponseStream()); string tmp = reader.ReadToEnd(); XDocument doc = XDocument.Parse(tmp); var result1 = doc.Root.Element("ticket").Element("subject").Value; var result2 = doc.Root.Element("ticket").Element("nice-id").Value; var result3 = doc.Root.Element("ticket").Element("Description").Value; }
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: get data from XML datatable
Nov 12, 2011 12:39 AM|LINK
Hello maduragnga001:)
You can in fact also use XDocument to deal with your prblem like this by looping the element layer by layer:
public static DataTable GetTickets()
{
HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(_myDomain + "/rules/651263.xml");
request.Method = "GET";
request.Credentials = new NetworkCredential(_Username, _Password);
request.ContentLength = 0;
HttpWebResponse resp = (HttpWebResponse)request.GetResponse();
StreamReader reader = new StreamReader(resp.GetResponseStream());
string tmp = reader.ReadToEnd();
XDocument doc = XDocument.Parse(tmp);
var result1 = doc.Root.Element("ticket").Element("subject").Value;
var result2 = doc.Root.Element("ticket").Element("nice-id").Value;
var result3 = doc.Root.Element("ticket").Element("Description").Value;
}