The field values are coming from a text file, there are 3 rows and the first column is ContactID, there are no null values for this column.

I have added a...

Hi Elliot,

I did not the line number in the error output.

So in this line i need to check for a ISNULL Value?

sqlCmd.Parameters("@ContactID").Value = Row.ContactID

Thank you

Great Article,

Thanks a bunch to the author.

Hi,

In the statement where you do the update, execute COMMIT TRAN

after the update statement, this will actually commit the transaction and close the open transaction.

BEGIN TRAN

UPDATE Test SET F2 =...