title: C# insert data into database windows form app
body: <p>I need to build a application where people can make a reservation but before doing that they need to fill in some information. I get this error code at the moment when i try to save the data: An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll</p>
  
  <p>This is my code:</p>
  
  <pre><code>using System;
  using System.Collections.Generic;
  using System.ComponentModel;
  using System.Data;
  using System.Data.SqlClient;
  using System.Drawing;
  using System.Linq;
  using System.Text;
  using System.Threading.Tasks;
  using System.Windows.Forms;
  
  namespace BonTemps
  {
      public partial class Home : Form
      {
          public Home()
          {
              InitializeComponent();
          }
  
          private void button1_Click(object sender, EventArgs e)
          {
              var Form1 = new Form1();
              Form1.Show();
          }
  
          private void tabPage1_Click(object sender, EventArgs e)
          {
  
          }
  
          private void label2_Click(object sender, EventArgs e)
          {
  
          }
  
          private void Home_Load(object sender, EventArgs e)
          {
              // TODO: This line of code loads data into the 'bonTempsDBDataSet.Tafel' table. You can move, or remove it, as needed.
              this.tafelTableAdapter.Fill(this.bonTempsDBDataSet.Tafel);
  
          }
  
          private void btnOpslaan_Click(object sender, EventArgs e)
          {
              SqlConnection sc = new SqlConnection();
              SqlCommand com = new SqlCommand();
              sc.ConnectionString = ("Data Source=ACER;Initial Catalog=BonTempsDB;Integrated Security=True");
              sc.Open();
  
              com.Connection = sc;
              com.CommandText = (@"INSERT INTO Klant (Naam, Adres, Woonplaats, Telefoonnummer, EmailAdres), VALUES ('" + txtNaam.Text + "','" + txtAdres.Text + "','" + txtWoon.Text + "','" + txtTel.Text + "','" + txtMail.Text + "'");
              com.ExecuteNonQuery();
  
              sc.Close();
  
          }
  
      }
  }
  </code></pre>