How do i add a row from one datatable to another?
I am looping through a for each in a datatable of names taken from a patient scheudle (dtPatientSched)
i use one name at a time to enter on a web page
I am going through a for each loop in datatable names scrapped from a webpage (dtWebNames).
if the patient’s name is on dtWebNames i add it the entire row of that patient in dtPatientSched to dtFoundPat. if the patient’s name is not found then I want to add it to the database dtNotFoundPat.
then i create a CSV for each dtFoundPat and dtNotFoundPat.
i am stuck copying the appropriate row from dtWebNames to the dtFoundPat and dtNotFoundPat tables.
i have tried Add new row and at best i get the error. This row already belongs to another table.
arrayrow i have tried numerous variations on variable of datarow types arrays, etc
datarow i leave blank
i do not know what i am doing wrong please be very explicit
also i have looked and played with invoke method, but i do not understand how to use it yet.