If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Re: Column count doesn't match value count at row 1

This is a fine example of one of the reasons that you should parameters when inserting values into SQL code: it makes the code much more readable and therefore less error-prone. Just as the error message says, the number of values doesn't match the number of columns. Did you count them? You are specifying that data should be inserted into 13 columns but you've provided 14 values. Those counts don't match by my reckoning.

Follow the Blog link in my signature below and check out my post on Parameters In ADO.NET. If you use parameters with the same names as the columns they are intended for then it's bleedingly obvious if they don't match.