title: There are more columns in the INSERT statement than values specified in the VALUES clause?
body: <p>I've been stumbling over this issue without being able to configure whats wrong in my sql insert statement. I need to insert a new row in a table but
   it keeps telling me that the columns in the insert statement are more than these in the clause.</p>
  
  <p>Here is my statement:</p>
  
  <pre><code>kSqlCommand.CommandText = "INSERT INTO BillsDetails ([BillID],[CallDialledID],[CallDateTime],[CallDuration],[CallNetPrice],[CallRetailPrice],[CallDiscountPrice]) VALUES ('" + strBillID + "','" + strDialledNumberID + "','" + strCallDate + "','" + strCallDuration + "','" + dCallNetPrice + "','" + dCallRetailPrice + "','" + dCallDiscountPrice + "')";//SqlStatement to Add new Bill
  kSqlCommand.ExecuteReader();
  </code></pre>
  
  <p>and each time I get this error:</p>
  
  <blockquote>
    <p>"There are more columns in the INSERT statement than values specified
    in the VALUES clause using c#. The number of values in the VALUES
    clause must match the number of columns specified in the INSERT
    statement."</p>
  </blockquote>
  
  <p>apparently, its a syntax issue, since columns in the INSERT statement = number of given values.</p>
  
  <p>any help will be appreciated..</p>