数据库数据转换为xml格式代码,C代码库,德仔网

代码语言

代码分类

【C】数据库数据转换为xml格式

作者:郭剑锋 / 发布于2013/6/20/ 556


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

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　数据库数据转换为xml　

同语言下

可能有用的

郭剑锋贡献的其它代码(14)