Passing Database Values Into an EXE for Encryption

[kermitcoder]

Hello, This is for VS 2005. I have a class which has a function that takes in a single account number and before inserting it into a SQL Server 2000 database table, applies DES3 encryption to the value. I have several thousand older records that exist in this column that are clear text that need to be encrypted. Would it be better to loop through the table/column values externally and pass those to the exe or should I do that in the function itself and just run the exe? Or do I need some kind of event to kick this off and therefore should use a form with a button_click event? For whatever scenario is best, could someone please show me an example of how I would do it? I'm not sure how to replace the single parm the function expects with all the values as they're passed back from the loop, which is why I was thinking maybe I should just do this in the function and run the exe. Not sure what to do in this case.

Thanks,
Joe