title: Creating Registration form in c# with mysql
body: <p>Hello so i m creating a registration form in C# with MySql so it connects to the database and everything but i get this error <code>Napaka pri registraciji</code> <code>Unknown column " in 'field list'</code> the translation of Napaka pri registraciji means Error at registering i just have it in my language. I get this error when i insert data in textboxes and press Register..</p>
  
  <p>the code:</p>
  
  <pre><code>private void btn_Reg_Click(object sender, EventArgs e)
      {
          MySqlConnection dataConnection = new MySqlConnection();
          dataConnection.ConnectionString = "datasource=localhost;port=3306;username=root;password=";
          dataConnection.Open();
          MySqlTransaction transakcija = dataConnection.BeginTransaction();
          MySqlCommand dataCommand = new MySqlCommand();
          dataCommand.Connection = dataConnection;
          dataCommand.Transaction = transakcija;
          try
          {
              dataCommand.CommandText = "Insert INTO lr.users (upIme,geslo) VALUES (`"+this.tB_upIme.Text+"`,`"+this.tB_geslo.Text+"`)";
              dataCommand.CommandType = CommandType.Text;
              dataCommand.ExecuteNonQuery();
              transakcija.Commit();
              MessageBox.Show("Registracija uspešna!");
          }
          catch (Exception eks)
          {
              transakcija.Rollback();
              MessageBox.Show("Napaka pri registraciji\n" + eks.Message);
          }
          finally
          {
              dataCommand.Connection.Close();
          }
      }
  </code></pre>