如何用ASP.Net從數据庫取數据生成并成送XML數据（不生成XML文件）？

最新推荐文章于 2024-09-22 15:25:09 发布

wfyscy

最新推荐文章于 2024-09-22 15:25:09 发布

阅读量543

点赞数

分类专栏： XML 文章标签： xml asp.net dataset import user object

XML 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

<%@ Page ContentType="text/xml" %>
<%@ Import Namespace="BLOG" %>
<%@ Import Namespace="System.Xml" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Text" %>
<script language="C#" runat="server">
void Page_Load(object sender, EventArgs e)
{
string user=Request["user"].ToString();
blogCOM bc=new blogCOM();
ArrayList al=new ArrayList();
al=bc.GetBlogInfo(user);
int userID=Convert.ToInt32(al[5]);
DataSet ds=new DataSet();
ds=bc.GetBlogTitle(userID,0,"0");
bc.Dispose();

XmlTextWriter writer = new XmlTextWriter(Response.OutputStream,null);

writer.WriteStartDocument();
writer.WriteStartElement("rss");
writer.WriteAttributeString("version","","2.0");

writer.WriteStartElement("channel");

writer.WriteStartElement("title");
writer.WriteString(al[3].ToString());
writer.WriteEndElement();

writer.WriteStartElement("link");
writer.WriteString("http://www.chinamacro.com/visit.aspx?user=" + user);
writer.WriteEndElement();

writer.WriteStartElement("description");
writer.WriteString(al[3].ToString());
writer.WriteEndElement();

writer.WriteStartElement("language");
writer.WriteString("zh-CN");
writer.WriteEndElement();

writer.WriteStartElement("pubDate");
writer.WriteString(al[4].ToString());
writer.WriteEndElement();

writer.WriteStartElement("webMaster");
writer.WriteString(al[7].ToString());
writer.WriteEndElement();

writer.WriteStartElement("image");

writer.WriteStartElement("title");
writer.WriteString(al[3].ToString());
writer.WriteEndElement();

writer.WriteStartElement("url");
writer.WriteString("http://www.chinamacro.com/blog/pic/logo.gif");
writer.WriteEndElement();

writer.WriteStartElement("link");
writer.WriteString("http://www.chinamacro.com/blog/visit.aspx?user=" + user);
writer.WriteEndElement();

writer.WriteEndElement();

for (int i=0;i<ds.Tables[0].Rows.Count;i++)
     {
        writer.WriteStartElement("item");

     writer.WriteStartElement("title");
     writer.WriteString(ds.Tables[0].Rows[i].ItemArray[1].ToString());
     writer.WriteEndElement();
     writer.WriteStartElement("link");
     writer.WriteString("http://www.chinamacro.com/blog/visit_detail.aspx?blogID=" + ds.Tables[0].Rows[i].ItemArray[0].ToString());
     writer.WriteEndElement();
     writer.WriteStartElement("description");
     writer.WriteString(ds.Tables[0].Rows[i].ItemArray[1].ToString());
     writer.WriteEndElement();
     writer.WriteStartElement("pubDate");
     writer.WriteString(ds.Tables[0].Rows[i].ItemArray[3].ToString());
     writer.WriteEndElement();

     writer.WriteEndElement();
     }