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