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