保存ADO的记录集为XML文件

最新推荐文章于 2025-04-09 12:09:08 发布

iteye_3619

最新推荐文章于 2025-04-09 12:09:08 发布

阅读量67

点赞数

本文演示了如何使用ADO连接到SQL Server数据库，并通过执行SQL查询将表数据以XML格式导出到文件中。代码示例展示了创建连接、设置查询参数、执行查询并将结果保存为XML文件的完整过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

#include "stdafx.h"
#import "c:\program files\common files\system\ado\msado15.dll" no_namespace rename("EOF","adoEOF")
int main(int argc,char* argv[])
{
printf("Export recordset as xml file\n");
CoInitialize(NULL);
try
{
_variant_tvarOptional(DISP_E_PARAMNOTFOUND,VT_ERROR);
_ConnectionPtr pConn("ADODB.Connection");
pConn->Open(_bstr_t("Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=Northwind;Data Source=(local)"),"","",adConnectUnspecified);
_StreamPtrstream;
stream.CreateInstance("ADODB.Stream");
stream->raw_Open(varOptional,adModeUnknown,adOpenStreamUnspecified,NULL,NULL);
stream->put_Type(adTypeText);
_CommandPtr Cmd1;
Cmd1.CreateInstance(__uuidof(Command));
Cmd1->ActiveConnection = pConn;
Cmd1->CommandText= _bstr_t("Select * from Table1 for XML Auto");
PropertiesPtr props;
props=Cmd1->GetProperties();
PropertyPtrprop;
prop = props->Item[_variant_t("XML Root")];
prop->PutValue(_variant_t("root"));
prop = props->Item[_variant_t("Output Stream")];
prop->PutValue(_variant_t((IDispatch *)stream, true));
Cmd1->Execute(&varOptional,&varOptional,adExecuteStream);
stream->SaveToFile("test.xml",adSaveCreateOverWrite);
printf("Save stream to file finished\n");
stream->Close();
pConn->Close();
}
catch(_com_error &e)
{
char buf[1024];
wsprintf(buf,"Description = '%s'\n", (char*)e.Description());
::MessageBox(NULL,buf,"error",MB_OK);
}
::CoUninitialize();
return 0;
}