62,072
社区成员
发帖
与我相关
我的任务
分享
ArrayList listElement = new ArrayList();
DataSet ListData = new DataSet();
DataSet dbset = GetDataSet("select top 83 * from Orders order by OrderID desc", listElement, 1);
Response.Charset = "utf-8";
Response.ContentType = "text/xml";
Response.Write("<?xml version='1.0' encoding='utf-8'?>");
Response.Write("<Root>");
Response.Write("<PageCounts>");
Response.Write("<page>" + PageGet(dbset.Tables[0].Rows.Count,10) + "</page>");
Response.Write("<Count>" + dbset.Tables[0].Rows.Count + "</Count>");
Response.Write("<Columns>");
for (int m = 0; m < listElement.Count; m++)
{
Response.Write("<DataColumns>" + listElement[m].ToString()+ "</DataColumns>");//将XML结构输出
}
Response.Write("</Columns>");
Response.Write("</PageCounts>");
for (int i = 0; i < dbset.Tables[0].Rows.Count; i++)
{
Response.Write("<News>");
for (int j = 0; j < listElement.Count; j++)
{
Response.Write("<" + listElement[j].ToString() + "><![CDATA[" + dbset.Tables[0].Rows[i][listElement[j].ToString()] + "]]></" + listElement[j].ToString() + ">");
}
Response.Write("</News>");
}
Response.Write("</Root>");
}
略.....
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="XmlNoth.aspx.cs" Inherits="XmlNoth" %>
<%@ OutputCache Duration="1" VaryByParam="None" %>
using System.IO;
protected void OpenXML(String strXML)
{
try
{
Response.ContentType = "text/xml";
StreamReader sr = new StreamReader(strXML);
string strLine = "";
strLine = sr.ReadLine();
while (strLine != null)
{
Response.Write(strLine);
strLine = sr.ReadLine();
}
sr.Dispose();
sr.Close();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Response.Clear();
Response.ContentType = "text/xml";
Response.Write(GetXMLStringFromDB());
}
private static string GetXMLStringFromDB()
{
return "<root><books><book name='asp.net developer' /></books></root>";
}