Guest User

Untitled

a guest
Mar 24th, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. HtmlWeb web = new HtmlWeb();
  2. var postedDate = web.Load(item);
  3. var dateNodes = postedDate.DocumentNode.SelectSingleNode("/html/body/section/section/section/div[2]/p[2]/time");
  4. var innerPostDates = dateNodes.InnerText;
  5. DateTime dateTime = Convert.ToDateTime(innerPostDates);
  6.  
  7. DateTime endTime = DateTime.Now.Date;
  8. MySqlDateNow = endTime.ToString("yyyy-MM-dd");
  9. MySqlEndDate = dateTime.ToString("yyyy-MM-dd");
  10. variables.startDate = MySqlEndDate;
  11. variables.endDate = MySqlDateNow;
  12.  
  13. string query = "INSERT INTO userproperties_temp(userID,clPostID,start,stop,pageHTML)VALUES('9999','" + variables.postID + "','" + MySqlEndDate + "','" + MySqlEndDate + "','" + item + "')";
Add Comment
Please, Sign In to add comment