主页
.NET Framework
ASP
Web Services
VB
图表区
分析与设计
组件/控件开发
LINQ
VC
问答

asp.net将datatable数据转换为xml下载

BrucesLong 2015-10-19 05:19:04

asp.net将datatable数据直接转换为xml并下载吗？
现在的程序是将datatable数据转换为xml文件并保持在服务器，然后再下载。不知道能跳过“将datatable生成xml文件保存在服务器”这一步，直接将datatable转换成xml文件下载吗？

...全文

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

ajianchina 2015-10-20


private string DataTableToXML(DataTable dt)
{
	MemoryStream stream = null;
	XmlTextWriter writer = null;
	try
	{
		stream = new MemoryStream();
		writer = new XmlTextWriter(stream, Encoding.Default);
		dt.WriteXml(writer);
		int count = (int)stream.Length;
		byte[] arr = new byte[count];
		stream.Seek(0, SeekOrigin.Begin);
		stream.Read(arr, 0, count);
		UTF8Encoding utf = new UTF8Encoding();
		return utf.GetString(arr).Trim();
	}
	catch
	{
		return String.Empty;
	}
	finally
	{
		if (writer != null) writer.Close();
	}
}

//输出XML：
System.Web.HttpContext.Current.Response.Clear();
System.Web.HttpContext.Current.Response.ContentType = "Text/XML";
System.Web.HttpContext.Current.Response.Expires = 0;
System.Web.HttpContext.Current.Response.Cache.SetNoStore();
System.Web.HttpContext.Current.Response.Write(DataTableToXML(datatable));//这里直接转换后进行输出
System.Web.HttpContext.Current.Response.End();

回复赞

老李家的小二 2015-10-20

http://blog.csdn.net/lbuskeep/article/details/6168516 http://www.cnblogs.com/lilin/archive/2010/04/18/1714927.html http://bbs.csdn.net/topics/380062478

回复赞