title: ExecuteNonQuery is working but , changes are not saving
body: <p>here is the code im working on ;</p>
  
  <pre><code> public partial class Form2 : Form
  {
      SqlConnection sc = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True");
      SqlDataAdapter sda;
      SqlCommand command;
      SqlCommand commands;
      public Form2()
      {
          InitializeComponent();
      }
  
      private void button2_Click(object sender, EventArgs e)
      {
          this.Close();
          Form1 f1 = new Form1();
          f1.Show();
      }
  
      private void button1_Click(object sender, EventArgs e)
      {
          command = new SqlCommand(@"SELECT * FROM [Table] WHERE email='" + textBox4.Text + "'", sc);
          sda = new SqlDataAdapter(command);
          DataSet ds = new DataSet();
          sda.Fill(ds);
          int i = ds.Tables[0].Rows.Count;
          if (i == 1)
  
              MessageBox.Show("Email Already Taken");
          else
          {
              sc.Open();
              command = new SqlCommand("INSERT INTO [Table](name,surname,yearofbirth,adress_home_city,adress_home_block,adress_home_street,adress_work_city,adress_work_block,adress_work_street,email,password) VALUES('"+textBox1.Text+"','"+textBox2.Text+ "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox7.Text + "','" + textBox10.Text + "','" + textBox11.Text + "','" + textBox8.Text + "','" + textBox9.Text + "','" + textBox6.Text + "') ", sc);
  
              command.ExecuteNonQuery();
              sc.Close();
              MessageBox.Show("Success");
  
          }
  </code></pre>
  
  <p>its working when im debugging it , its a register form and i can login with the information i give in this form.</p>
  
  <p>but when closed , this insert command i do doesnt get saved in my database.</p>
  
  <p>// additional info ;</p>
  
  <p>when in register form , i get the success message and if i try again with same information , i get the email is already taken message</p>