I have a problem where an .aspx page inserts data into database. In order to do this I have a function in a vb.class which carries out the insert. The function returns a string which informs the user if the insert was successful. The inserting of data happens in two steps. The first is a simple insert query and the second is a bulk insert.
My function (insertData) carries out the insert query and then calls a routine (bulkInsert) to carry out the bulk insert. In order to handle any errors I'm using a try-catch statement in the function (insertdata). There is no error handling in the routine (bulkInsert), my reasoning being any errors would be passed back to the calling function and would be handled there.
During my testing things aren't happening as I would expect. I'm deliberately causing an error in the routine. From my debugging scripts I can see that the error is being passed back to the function and is being handled. However the function seem ...
Go to the complete details ...