dt = new DataTable("Accountdata");
dt.Columns.Add("Account ID");
dt.Columns.Add("Company Name");
dt.Columns.Add("City");
dt.Columns.Add("Country");
dt.Columns.Add("Email");
dt.Columns.Add("Enabled");
XmlDocument XMLDoc = new XmlDocument();
Stream responseStream = response.GetResponseStream();
XMLDoc.Load(responseStream);
foreach (XmlNode AccData in XMLDoc.SelectNodes("/response/accounts/account"))
{
if (AccData["accountId"] == null)
{
continue;
}
else
{
int AccountId = Convert.ToInt32(AccData["accountId"].InnerText);
string CompanyName = AccData["companyName"].InnerText;
string City = AccData["city"].InnerText;
string Country = AccData["country"].InnerText;
string Email = AccData["email"].InnerText;
int Enabled = Convert.ToInt32(AccData["enabled"].InnerText);
dt.Rows.Add(AccountId, CompanyName, City, Country, Email, Enabled);
}
}