I am making a web application that takes RSS feeds from websites(URLs are in database) and then loads them into my web application. But I am getting this error
System.Xml.XmlException: Root element is missing. root element is missing. at line : rssdoc.load(rssStream);
Exception Details: System.Xml.XmlException: There are multiple root elements. Line 2, position 2. so how to encapsulate everything else by single xml element
Here is my code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Xml;
using System.Net;
using System.Text;
using System.IO;
using System.Data;
using System.Data.SqlClient;
public partial class poletics : System.Web.UI.Page
{
public SqlConnection oldbcon = new SqlConnection();
static int n = 0;
static DataTable dt = new DataTable();
protected void Page_Load(object sender, EventArgs e)
{
oldbcon = opncon();
using (oldbcon)
{
SqlDataAdapter ad = new SqlDataAdapter("SELECT * from LebPolRss", oldbcon);
ad.Fill(dt);
}
int f = 3;
while (n < f)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Literal feed = new Literal();
try
{
feed.Text = ProcessRss(dt.Rows[i][3].ToString(), dt.Rows[i][4].ToString());
}
catch (WebException ex)
{
WebResponse response = ex.Response;
}
Panel1.Controls.Add(feed);
}
n++;
}
}
public static string ProcessRss(string rssUrl, string feed)
{
WebRequest request = WebRequest.Create(rssUrl);
WebResponse response = request.GetResponse();
StringBuilder sb = new StringBuilder("");
Stream rssStream = response.GetResponseStream();
XmlDocument rssDoc = new XmlDocument();
rssDoc.Load(rssStream);//here is the line where the exception thrown
XmlNodeList rssItems = rssDoc.SelectNodes("rss/channel/item");
string title = "";
string link = "";
string description = "";
int upperlimit = rssItems.Count;
if (upperlimit > n)
upperlimit = n + 1;
if (upperlimit > 0)
{
sb.Append("<ul>");
for (int i = 0; i < upperlimit - n; i++)
{
XmlNode rssDetail;
rssDetail = rssItems.Item(i + n).SelectSingleNode("title");
if (rssDetail != null)
{
if (feed.ToString().Equals("tayyar"))
{
title = rssDetail.InnerText.Substring(5);
}
else
{
if (rssDetail.InnerText.Length > 75)
{
title = rssDetail.InnerText.Substring(0, 75);
}
else
{
title = rssDetail.InnerText;
}
}
}
else
{
title = "";
}
rssDetail = rssItems.Item(i + n).SelectSingleNode("link");
if (rssDetail != null)
{
if (feed.ToString().Equals("tayyar"))
{
if (rssDetail.InnerText.Substring(0, 21).CompareTo("http://www.tayyar.org") != 0)
{
link = "http://www.tayyar.org" + rssDetail.InnerText;
}
else
{
link = rssDetail.InnerText;
}
}
else
{
link = rssDetail.InnerText;
}
}
else
{
link = "";
}
rssDetail = rssItems.Item(i + n).SelectSingleNode("description");
if (rssDetail != null)
{
if (!rssDetail.InnerText.Substring(3, 3).Equals("Ad:"))
{
description = rssDetail.InnerText;
}
}
else
{
description = "";
}
switch (feed)
{
case "tayyar": sb.Append("<div class='imgsep'><li><img src='logos/tayyar.jpg' width='50px' height='30px'/> <a href='" + link + "' target='_blank'>" + title + "</a> <img src='Images/smallarrow.png'/></li></div>");
break;
case "14march": sb.Append("<div class='imgsep'><li><img src='logos/14march.jpg' width='50px' height='30px'/> <a href='" + link + "' target='_blank'>" + title + "</a> <img src='Images/smallarrow.png'/></li></div>");
break;
case "annahar": sb.Append("<div class='imgsep'><li><img src='logos/annahar.jpg' width='50px' height='30px'/> <a href='" + link + "' target='_blank'>" + title + "</a> <img src='Images/smallarrow.png'/></li></div>");
break;
case "alakhbar": sb.Append("<div class='imgsep'><li><img src='logos/akhbar.jpg' width='50px' height='30px'/> <a href='" + link + "' target='_blank'>" + title + "</a> <img src='Images/smallarrow.png'/></li></div>");
break;
case "sadabeirut": sb.Append("<div class='imgsep'><li><img src='logos/echobeirut.png' width='50px' height='30px'/> <a href='" + link + "' target='_blank'>" + title + "</a> <img src='Images/smallarrow.png'/></li></div>");
break;
case "assafir": sb.Append("<div class='imgsep'><li><img src='logos/assafir.png' width='50px' height='30px'/> <a href='" + link + "' target='_blank'>" + title + "</a> <img src='Images/smallarrow.png'/></li></div>");
break;
case "aliwaa": sb.Append("<div class='imgsep'><li><img src='logos/aliwaa.jpg' width='50px' height='30px'/> <a href='" + link + "' target='_blank'>" + title + "</a> <img src='Images/smallarrow.png'/></li></div>");
break;
}
}
sb.Append("</ul>");
}
return sb.ToString();
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
oldbcon = opncon();
using (oldbcon)
{
SqlDataAdapter ad = new SqlDataAdapter("SELECT * from LebPolRss", oldbcon);
ad.Fill(dt);
}
n = 4;
for (int i = 0; i < dt.Rows.Count; i++)
{
Literal feed = new Literal();
try
{
feed.Text = ProcessRss(dt.Rows[i][3].ToString(), dt.Rows[i][4].ToString());
}
catch (WebException ex) { WebResponse response = ex.Response; }
Panel1.Controls.Add(feed);
}
LinkButton1.Visible = false;
}
public static SqlConnection opncon()
{
string connectionString = "Data Source=RAYYAN-THINK;Initial Catalog=newsProject;Integrated Security=True";
SqlConnection conn = new SqlConnection(connectionString);
return conn;
}
}
Stack Trace:
[XmlException: Root element is missing.]
System.Xml.XmlTextReaderImpl.Throw(Exception e) +69
System.Xml.XmlTextReaderImpl.ParseDocumentContent() +5589128
System.Xml.XmlTextReaderImpl.Read() +215
System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace) +145
System.Xml.XmlDocument.Load(XmlReader reader) +107
System.Xml.XmlDocument.Load(Stream inStream) +130
poletics.ProcessRss(String rssUrl, String feed) in c:\Users\RAYYAN\Documents\Visual Studio 2012\WebSites\WebSite1\poletics.aspx.cs:57
poletics.Page_Load(Object sender, EventArgs e) in c:\Users\RAYYAN\Documents\Visual Studio 2012\WebSites\WebSite1\poletics.aspx.cs:36
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
System.Web.UI.Control.OnLoad(EventArgs e) +92
System.Web.UI.Control.LoadRecursive() +54
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772
{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://img.manongdao.com/sparkler-677774__340.jpg', '推荐 祖国的老花朵 的文章《System.Xml.XmlException - Root element is missing》','https://www.manongdao.com/article-995410.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}