#include "stdafx.h"
using namespace System;
using namespace System::Configuration;
using namespace System::Data;
using namespace System::Data::SqlClient;
using namespace System::Xml;
void Navigate(XmlNode ^node, int depth)
{
if (node == nullptr)
return;
Console::WriteLine(depth);
Console::WriteLine(node->NodeType.ToString());
Console::WriteLine(node->Name);
Console::WriteLine(node->Value);
if (node->Attributes != nullptr)
{
for (int i = 0; i < node->Attributes->Count; i++)
{
Console::WriteLine(node->Attributes[i]->Name);
Console::WriteLine(node->Attributes[i]->Value);
}
}
Navigate(node->FirstChild, depth+1);
Navigate(node->NextSibling, depth);
}
void main(){
XmlDocument ^doc = gcnew XmlDocument();
SqlConnection ^connect = gcnew SqlConnection();
connect->ConnectionString = "SQLConnection";
SqlDataAdapter ^dAdapt = gcnew SqlDataAdapter();
DataSet ^dSet = gcnew DataSet();
dAdapt->SelectCommand = gcnew SqlCommand("SELECT * FROM Authors", connect);
dAdapt->Fill(dSet, "Authors");
XmlDataDocument ^doc1 = gcnew XmlDataDocument(dSet);
Navigate(doc1->DocumentElement, 0);
}