yuvipoy (9/25/2012)
I have missed the last 2 lines command.ExecuteNonQuery(); and command.Parameters.Clear(); statement in the code.
Yes, adding those two lines fixes that issue.
However, you will have very poor performance - you could get orders of magnitude improvement in time to insert by using a set-based method.
Tom