I have a webpage and I need to refresh the web page at a given interval and scrape the content. If there are new items in the datatable in the web page, I want to send out the datarow via email.
The solution I can think of is to scrape the first instance then combine it with the new ones. Then combine the datatable and lastly remove the duplicates.
Although for some reason the 1st and 2nd rows still have duplicates.
I’m using the below method to remove my duplicates
Customer=CustomerTable.AsEnumerable().GroupBy(Function(a) a.Field(Of String)(“Lead ID”)).Select(Function(b) b.First).CopyToDataTable()