Datele nu raman salvate in sql la redeschiderea programului

Program de lucru: Visual Basic 2008
Mediul de lucru: C Sharp
Baza de date: Sql.mdf
Nivel cunostinte: incepator

Am creat o baza de date in sql si un formular prin intermediul caruia sunt introduse datele.
Am introdus data setul, databindingul si tableadapterul

Am introdus si un buton de salvare a datelor cu urmatorul cod:

Varianta 1:

private void button1_Click(object sender, EventArgs e)
        {

            string IDClient;
            string NumeClient;
            string PrenumeClient;
            string Tara;
            string Oras;
            string Strada;
          

            //Atribuiri

            IDClient = IDClientTextBox.Text;
            NumeClient = NumeClientTextBox.Text;
            PrenumeClient = PrenumeClientTextBox.Text;
            Tara = TaraTextBox.Text;
            Oras = OrasTextBox.Text;
            Strada = StradaTextBox.Text;

            DataRow newRow = showRoomAutoDataSet.Clienti.NewRow();
            newRow["IDClient"] = IDClient.Substring(0);
            newRow["NumeClient"] = NumeClient.Substring(0);
        
            try
            {
                showRoomAutoDataSet.Clienti.Rows.Add(newRow);
                clientiTableAdapter.Update(showRoomAutoDataSet.Clienti);
                showRoomAutoDataSet.AcceptChanges();
            


                MessageBox.Show("DB Updated!");
                Application.DoEvents();

                
            }
            catch (OleDbException ex)
            {
                showRoomAutoDataSet.RejectChanges();
                MessageBox.Show(ex.Message);
                MessageBox.Show(ex.ErrorCode.ToString());
            }
          
        
        }
Varianta 2:

clientiBindingSource.EndEdit();
            tranzactiiDetaliiBindingSource.EndEdit();
            int result = 0;
            result = clientiTableAdapter.Update(showRoomAutoDataSet.Clienti);
            tranzactiiTableAdapter.Update(showRoomAutoDataSet.Tranzactii);
            MessageBox.Show(result.ToString()," Numar Inregistrari adaugate");

Varianta 3:

this.Validate();
this.clientiBindingSource.EndEdit();
this.clientiTableAdapter.Update(this.showRoomAutoDataSet.Clienti);

Nici una din variantele de mai sus nu salveaza datele in baza de date sql. Daca ies din modul debug si re-rulez programul, datele sunt acolo, dar
nu si in tabelele bazei de date, daca dau refresh. La inchiderea si redeschiderea proiectului, totul a disparut.

Va rog sa imi dati o idee.