I have a loop writes data into a sql database which it reads from a datareader.

Once the first record is added, a return value must be specified from the stored procedure in:

        Do While myDataReader.Read

            cmdInsertCurrency.Parameters.Clear() 'Clear the return value for adding of the next available record
            cmdInsertCurrency.Parameters.Add("@RETURN VALUE", DbType.Int32, 0)
            cmdInsertCurrency.Parameters("@RETURN VALUE").Direction = ParameterDirection.ReturnValue
            cmdInsertCurrency.Parameters.Add("@CURRENCY_ID", DBNull.Value)
            cmdInsertCurrency.Parameters.Add("@CURRENCY_CODE", myDataReader.Item(1))
            cmdInsertCurrency.Parameters.Add("@CURRENCY_NAME", myDataReader.Item(2))
            cmdInsertCurrency.Parameters.Add("@START_DATE", #1/1/2000#)
            cmdInsertCurrency.Parameters.Add("@END_DATE", #12/31/9998#)
            cmdInsertCurrency.Parameters.Add("@CHANGE_ID", Decimal.Zero)
            cmdInsertCurrency.Parameters.Add("@SITE_AUDIT_ID", "20120050027000001")
            cmdInsertCurrency.Parameters.Add("@USER_AUDIT_ID", "c242242")
            cmdInsertCurrency.Parameters.Add("@PARENT_AUDIT_ID ", DBNull.Value)

            Try
                myParamAdapter.InsertCommand = cmdInsertCurrency
                cmdInsertCurrency.ExecuteNonQuery()
            Catch ex As Exception
                MsgBox(ex.Message)
                Exit Do
            Finally
                Console.WriteLine(iNumOfRecordsAffected)
            End Try

            iNumOfRecordsAffected += 1

        Loop

It writes my values to the database correctly, but appart from the @RETURN VALUE I specified, I also want to return the value assigned to "@CURRENCY_ID" which is a GUID in my database. Is there any way that I can tell the loop what this value is, as I keep getting a null value returned in the console window.

Can anybody please help me out?