title: Adding textbox values to an SQL database in c#
body: <p>I'm trying to add values from a textbox into a datagridview, I have asked this question before but I'm now getting a different error saying </p>
  
  <blockquote>
    <p>There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.</p>
  </blockquote>
  
  <p>This is the code causing the error</p>
  
  <pre><code>private void SaveBtn_Click(object sender, EventArgs e)
  {
      SqlConnection sc = new SqlConnection();
      SqlCommand com = new SqlCommand();
      sc.ConnectionString = ("Data Source=localhost;Initial Catalog=LoginScreen;Integrated Security=True");
      sc.Open();
      com.Connection = sc; 
      com.CommandText = ("INSERT INTO Stock (Prod_ID, Prod_Name, Prod_Cat, Supplier, Cost, Price_1, Price_2, Price_3) VALUES ('"+ProdID.Text+"''"+ProdName.Text+"'+'"+ProdCat.Text+"'+'"+ProdSup.Text+"'+'"+ProdCost.Text+"'+'"+ProdPrice1.Text+"'+'"+ProdPrice2.Text+"'+'"+ProdPrice3.Text+"');");
      com.ExecuteNonQuery();
      sc.Close();
  }
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/KTeqN.png" rel="nofollow noreferrer">my database</a></p>