private void PopulateRssFeed() { //string RssFeedUrl = "http://timesofindia.feedsportal.com/c/33039/f/533965/index.rss"; //string RssFeedUrl = "http://newsfirst.lk/sinhala/feed/"; //string RssFeedUrl = "http://www.lankadeepa.lk/index.php/maincontroller/breakingnews_rss"; string RssFeedUrl = "http://www.hirunews.lk/rss/sinhala.xml"; //string RssFeedUrl = "http://sinhala.adaderana.lk/rsshotnews.php"; List<Feeds> feeds = new List<Feeds>(); try { int k = 0; XDocument xDoc = new XDocument(); xDoc = XDocument.Load(RssFeedUrl); var items = (from x in xDoc.Descendants("item") select new { title = x.Element("title").Value, link = x.Element("link").Value, pubDate = x.Element("pubDate").Value, description = x.Element("description").Value }); if (items != null) { foreach (var i in items) { Feeds f = new Feeds { Title = i.title, Link = i.link, PublishedDate = i.pubDate, Description = i.description }; feeds.Add(f); //------------other stuff----------- if (k < 1) { //------------writing in to the text file-----------C:\Users\Madhuka Dilshan\Desktop StreamWriter File = new StreamWriter(@"C:\Users\Madhuka Dilshan\Desktop\News_text.txt", true); File.WriteLine(f.Description + " /n" + f.Title); //File.Write("Hello world"); File.Close(); //------------Add to database----------- SqlConnection cs = new SqlConnection("Data Source=DIL;Initial Catalog=finalyear;Integrated Security=True"); //SqlConnection cs = new SqlConnection("Data Source = HP_TDK; Initial Catalog = NewsDB; Integrated Security=TRUE"); SqlDataAdapter da = new SqlDataAdapter(); da.InsertCommand = new SqlCommand("INSERT INTO kk VALUES(@title, @link, @Description, @Pub_date)", cs); da.InsertCommand.Parameters.Add("@title", SqlDbType.NVarChar, 100).Value = f.Title.Trim(); da.InsertCommand.Parameters.Add("@link", SqlDbType.NVarChar, 100).Value = f.Link.Trim(); da.InsertCommand.Parameters.Add("@Description", SqlDbType.NVarChar, 100).Value = f.Description.Trim(); da.InsertCommand.Parameters.Add("@Pub_date", SqlDbType.NVarChar, 100).Value = f.PublishedDate.Trim(); cs.Open(); da.InsertCommand.ExecuteNonQuery(); cs.Close(); //k = 2; } //----------------------- } } gvRss.DataSource = feeds; gvRss.DataBind(); } catch(Exception ex) { throw; } }
private void PopulateRssFeed() { //string RssFeedUrl = "http://timesofindia.feedsportal.com/c/33039/f/533965/index.rss"; //string RssFeedUrl = "http://newsfirst.lk/sinhala/feed/"; //string RssFeedUrl = "http://www.lankadeepa.lk/index.php/maincontroller/breakingnews_rss"; string RssFeedUrl = "http://www.hirunews.lk/rss/sinhala.xml"; //string RssFeedUrl = "http://sinhala.adaderana.lk/rsshotnews.php"; List <Feeds> feeds = new List <Feeds>(); try { int k = 0; XDocument xDoc = new XDocument(); xDoc = XDocument.Load(RssFeedUrl); var items = (from x in xDoc.Descendants("item") select new { title = x.Element("title").Value, link = x.Element("link").Value, pubDate = x.Element("pubDate").Value, description = x.Element("description").Value }); if (items != null) { foreach (var i in items) { Feeds f = new Feeds { Title = i.title, Link = i.link, PublishedDate = i.pubDate, Description = i.description }; feeds.Add(f); //------------other stuff----------- if (k < 1) { //------------writing in to the text file-----------C:\Users\Madhuka Dilshan\Desktop StreamWriter File = new StreamWriter(@"C:\Users\Madhuka Dilshan\Desktop\News_text.txt", true); File.WriteLine(f.Description + " /n" + f.Title); //File.Write("Hello world"); File.Close(); //------------Add to database----------- SqlConnection cs = new SqlConnection("Data Source=DIL;Initial Catalog=finalyear;Integrated Security=True"); //SqlConnection cs = new SqlConnection("Data Source = HP_TDK; Initial Catalog = NewsDB; Integrated Security=TRUE"); SqlDataAdapter da = new SqlDataAdapter(); da.InsertCommand = new SqlCommand("INSERT INTO kk VALUES(@title, @link, @Description, @Pub_date)", cs); da.InsertCommand.Parameters.Add("@title", SqlDbType.NVarChar, 100).Value = f.Title.Trim(); da.InsertCommand.Parameters.Add("@link", SqlDbType.NVarChar, 100).Value = f.Link.Trim(); da.InsertCommand.Parameters.Add("@Description", SqlDbType.NVarChar, 100).Value = f.Description.Trim(); da.InsertCommand.Parameters.Add("@Pub_date", SqlDbType.NVarChar, 100).Value = f.PublishedDate.Trim(); cs.Open(); da.InsertCommand.ExecuteNonQuery(); cs.Close(); //k = 2; } //----------------------- } } gvRss.DataSource = feeds; gvRss.DataBind(); } catch (Exception ex) { throw; } }