Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- HtmlWeb web = new HtmlWeb();
- var postedDate = web.Load(item);
- var dateNodes = postedDate.DocumentNode.SelectSingleNode("/html/body/section/section/section/div[2]/p[2]/time");
- var innerPostDates = dateNodes.InnerText;
- DateTime dateTime = Convert.ToDateTime(innerPostDates);
- DateTime endTime = DateTime.Now.Date;
- MySqlDateNow = endTime.ToString("yyyy-MM-dd");
- MySqlEndDate = dateTime.ToString("yyyy-MM-dd");
- variables.startDate = MySqlEndDate;
- variables.endDate = MySqlDateNow;
- 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