Hey All,
I have 2 DataTables that I have populated from 2 different databases using 2 separate functions using the code bellow.
Where I am stumped is I am trying to compare the two using the Items_ID value. If the Items_ID value exists in both it means that the status of the Inventory item in the database needs to be changed from 'I' to 'S'. First I just want to use the Items_ID
value from the pmDT and if a matching Items_ID is found in the onlineDT then I want to populate another DataTable that I will be using for the actual maintenance of the database in another function.
Any thought or suggestions on what I can do to compare the DataTable Results?
Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
Dim pmDT As New DataTable
pmDT = getPMSoldItems()
Dim onlineDT As New DataTable
onlineDT = getOnlineItems()
End Sub
Go to the complete details ...