Hi,

I am trying to develop a console application that uses ExecuteReader to accces selected entries from one table and depending on the contents of each row insert an entry to a second table using ExecuteNonQuery.

Unfortunately the program abends with a pop-up window stateing that the "<program> has stopped working" on the insert function.

If the reader is closed before the insert than it works but only one row can be processed.

I have attached a test program to show the basic structure of the requirement.

Paul