VB.Net - Hold Variable Number of Items While Looping Through DataReader
Posted on 2015-01-02
Good Day Experts and Happy New Year!
I have a new request for one of my projects today.
While iterating through my DataReader I am inserting records into a SQL table. Then at the end of the function I am sending and email out to Users before displaying a complete messageBox. I need to be able to save each key value of the inserted records so I can send them in the body of the email. The number of records will not be known. The DataReader could have 5 or 50 or 100 or more to insert.
So how can I save the primary key values of each record inserted so I can send later in the email?
Thanks for the insight,