Hello,

I have a visual C# project and i'm trying to insert data in a MS Access Database when i press a button. Here is the code:

private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                OleDbDataAdapter adapter=new OleDbDataAdapter();
                adapter.InsertCommand = new OleDbCommand();
                adapter.InsertCommand.CommandText =
                     "insert into Candidati values ('" + maskedTextBox1.Text.Trim() + "','" + textBox1.Text.Trim() + "', '" + textBox2.Text.Trim() + "', '" + textBox3.Text.Trim() + "','" + Convert.ToDouble(maskedTextBox2.Text) + "','" + Convert.ToDouble(maskedTextBox3.Text) + "')";
                con.Open();
                adapter.InsertCommand.Connection = con;
                adapter.InsertCommand.ExecuteNonQuery();
                con.Close();
                MessageBox.Show("Inregistrare adaugata cu succes!");
                maskedTextBox1.Text = null;
                maskedTextBox2.Text = null;
                maskedTextBox3.Text = null;
                textBox1.Text = null;
                textBox2.Text = null;
                textBox3.Text = null;
                maskedTextBox1.Focus();
            }
            catch (AdmitereException exc)
            {
                MessageBox.Show("A aparut o exceptie: "+exc.Message, "Eroare!", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

The connection string is:

private static string connectionString;
        OleDbConnection con;
        public AddCandidati()
        {
            connectionString = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=Admitere.mdb";
            con = new OleDbConnection(connectionString);
            InitializeComponent();
        }

Where AddCandidati is the form. The data is not saved in the database, why? I have the .mdb file in the project folder.. What i'm doing wrong? I did not got any exception when i press the button..

Thanks!