asp.net SQL Server insert statement tidyup + error
<p>I have a form which inserts data into a database.</p>

<p>There are certain fields that are not always going to be needed.
When I leave these blank in my code I get a error saying.</p>

<blockquote>
  <p>Column name or number of supplied values does not match table
  definition.</p>
</blockquote>

<p>This is how I have the database setup. SQL Server 2008</p>

<pre><code>[youthclubid]
[youthclubname]
[description]
[address1]
[address2]
[county]
[postcode]
[email]
[phone]
</code></pre>

<p>Here is the code that I have connecting to the database and doing the insert.</p>

<pre><code>connection.Open();
cmd = new SqlCommand("insert into youthclublist values ('" + youthclubname.Text + "', '" + description.Text + "','" + address1.Text + "','" + address2.Text + "', '" + county.Text + "', '" + postcode.Text + "', '" + email.Text + "', '" + phone.Text + "')", connection);
cmd.ExecuteNonQuery();
</code></pre>
