title: update data using oledb in c#
body: <p>I made a project using c# and data base using access accdb and connected between them both. I made 2 buttons, first one to add new costumer, which works perfectly, and second one to update the data of the costumer (first name and last name), for some reason, the update button does not work, there is no error when I run the project, but after I click nothing happens...</p>
  
  <pre><code>private void button2_Click(object sender, EventArgs e)
  {
      connect.Open();
      string cid = textBox1.Text;
      string cfname = textBox2.Text;
      string clname = textBox3.Text;
      OleDbCommand command = new OleDbCommand();
      command.Connection = connect;
      command.CommandText = "UPDATE Tcostumers SET cfname= " + cfname + "clname= " + clname + " WHERE cid = " + cid;
      if (connect.State == ConnectionState.Open)
      {
          try
          {
              command.ExecuteNonQuery();
              MessageBox.Show("DATA UPDATED");
              connect.Close();
          }
          catch (Exception expe)
          {
              MessageBox.Show(expe.Source);
              connect.Close();
          }
      }
      else
      {
          MessageBox.Show("ERROR");
      }
  }
  </code></pre>