从sql server读取数据到xml文件代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】从sql server读取数据到xml文件

作者:Catherine / 发布于2014/10/10/ 805

String methodName = Thread.currentThread().getStackTrace()[1].getMethodName();


	using System;
	using System.Data;
	using System.Xml;
	using System.Data.SqlClient;
	using System.IO;
	public class TestWriteXML
	{
	 public static void Main()
	 {
	 String strFileName=c:/temp/output.xml;
	 SqlConnection conn = new SqlConnection(server=localhost;uid=sa;pwd=;database=db);
	 String strSql = SELECT FirstName, LastName FROM employees;
	 SqlDataAdapter adapter = new SqlDataAdapter();
	 adapter.SelectCommand = new SqlCommand(strSql,conn);
	 // Build the DataSet
	 DataSet ds = new DataSet();
	 adapter.Fill(ds, employees);
	 // Get a FileStream object
	 FileStream fs = new FileStream(strFileName,FileMode.OpenOrCreate,FileAccess.Write);
	 // Apply the WriteXml method to write an XML document
	 ds.WriteXml(fs);
	 fs.Close();
	 }
	}

试试其它关键字

　当前方法　

同语言下

可能有用的

Catherine贡献的其它代码(3)