That's a great point Jeff. No reason to loop through the parameters. I noticed you also added the SqlDbTypes, which I had omitted. Thanks. I'm going to experiment with a version of this page that uses TVP's. They look very promising.

That's probably what it is. And come to thing of it I could also use SQL GetDate().

Aristos, can you spot anything I may have done wrong? When I run the app nothing actually inserts into the database. I'm not noticing any exceptions either. edit: I'm going with your recommended code by the way.

Yes I am actually. Interesting suggestion. I'm going to investigate that. For this project I am the database developer too.

Thanks. I plan to add layers for data access and business logic later. For the moment it's just simpler for me to work with fewer layers as I'm still learning.