我想在xml文件中打开此代码。这次此代码在aspx页面上运行。 [英] i want open this code in xml file.this time this code running on aspx page.

问题描述

//i want run this code on xml file
string connectionString = "Data Source=SANJAY-PC\\SQLEXPRESS;Initial Catalog=Project;Integrated Security=True";
DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(connectionString);

using (conn)
{
    SqlDataAdapter ad = new SqlDataAdapter("SELECT * from tbRss", conn);
    ad.Fill(dt);
}

Response.Clear();
Response.ContentType = "text/xml";
XmlTextWriter TextWriter = new XmlTextWriter(Response.OutputStream, Encoding.UTF8);
TextWriter.WriteStartDocument();

//Below tags are mandatory rss
TextWriter.WriteStartElement("rss");
TextWriter.WriteAttributeString("version", "2.0");

// Channel tag will contain RSS feed details
TextWriter.WriteStartElement("channel");
TextWriter.WriteElementString("title", "C#.NET,ASP.NET Samples and Tutorials");
TextWriter.WriteElementString("link", "http://google.com");
TextWriter.WriteElementString("description", "All is well");
TextWriter.WriteElementString("copyright", "Copyright 2009 - 2010");

foreach (DataRow oFeedItem in dt.Rows)
{
    TextWriter.WriteStartElement("item");
    TextWriter.WriteElementString("title", oFeedItem["Title"].ToString());
    TextWriter.WriteElementString("description", oFeedItem["Descripion"].ToString());
    TextWriter.WriteElementString("link", oFeedItem["URL"].ToString());
    TextWriter.WriteEndElement();
}

TextWriter.WriteEndElement();
TextWriter.WriteEndElement();
TextWriter.WriteEndDocument();
TextWriter.Flush();
TextWriter.Close();
Response.End();

推荐答案

问题



仅发布代码块并期待我们的答案是一个非常糟糕的主意。



要求



请解释要求和方案。我们应该知道你想要达到的目的。



问题



下一步是 - 描述你试图完成任务的内容。

如果你在当前代码中遇到问题，那么请解释它到底发生了什么。



建议



逐行调试代码，看看究竟是什么问题。

Problem

Posting only a code block and expecting answers from our side is a very bad idea.

Requirements

Please explain the requirement and scenario. We should know what exactly you are trying to achieve.

Issue

Next thing is - describe what you have tried to achieve the task.
If you are facing issues in the current code, then explain where exactly it is happening.

Suggestion

Debug your code line by line and see where exactly is the issue.

SqlDataAdapter ad = new SqlDataAdapter（SELECT * from tbRss，conn）;

ad.Fill（dt）;

FileInfo TheFile = new FileInfo （MapPath（Sample.xml））;

if（TheFile.Exists）

{

File.Delete（MapPath（Sample） .xml））;

}

XmlTextWriter TextWriter = new XmlTextWriter（Server.MapPath（Sample.xml），Encoding.UTF8）;

TextWriter.WriteStartDocument（）;

TextWriter.WriteStartElement（rss）;

TextWriter.WriteAttributeString（version，2.0）;

foreach（dt.Rows中的DataRow oFeedItem）

{

TextWriter.WriteStartElement （item）;

TextWriter.WriteElementString（title，oFeedItem [Title]。ToString（））;

TextWriter.WriteElementString（description， oFeedItem [Descriptio]。ToString（））;

TextWriter.WriteElementString（link，oFeedItem [URL]。ToString（））;



TextWriter.WriteEndElement（）;

}

TextWriter.WriteEndElement（）;

TextWriter.WriteEndDocument（）;

TextWriter.Flush（）;

TextWriter.Close（）;

Response.Redirect（Sample.xml）;

SqlDataAdapter ad = new SqlDataAdapter("SELECT * from tbRss", conn);
ad.Fill(dt);
FileInfo TheFile = new FileInfo(MapPath("Sample.xml"));
if (TheFile.Exists)
{
File.Delete(MapPath("Sample.xml"));
}
XmlTextWriter TextWriter = new XmlTextWriter(Server.MapPath("Sample.xml"), Encoding.UTF8);
TextWriter.WriteStartDocument();
TextWriter.WriteStartElement("rss");
TextWriter.WriteAttributeString("version", "2.0");
foreach (DataRow oFeedItem in dt.Rows)
{
TextWriter.WriteStartElement("item");
TextWriter.WriteElementString("title", oFeedItem["Title"].ToString());
TextWriter.WriteElementString("description", oFeedItem["Descriptio"].ToString());
TextWriter.WriteElementString("link", oFeedItem["URL"].ToString());

TextWriter.WriteEndElement();
}
TextWriter.WriteEndElement();
TextWriter.WriteEndDocument();
TextWriter.Flush();
TextWriter.Close();
Response.Redirect("Sample.xml");

这篇关于我想在xml文件中打开此代码。这次此代码在aspx页面上运行。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！