#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 );
}