SqlCommand comm =
new SqlCommand("UPDATE Contatos Set Telefone=" + " ' " + txtTelefone.Text + " ' " + ",Cidade=" + " ' " + txtCidade.Text + " ' " + ",Email=" + " ' " + txtEmail.Text + " ' " + ",Endereco=" + " ' " + txtEndereco.Text + " ' " + "WHERE Nome=" + txtNome.Text, conn);
Error: "Column Name 'is the name that is in the' Invalid 'txtName. The error message shows as if I had been trying to fetch the name of a column, where the column name is txtName.Text. My intention was for the sql command to update the contact information according to its name. I have little experience with sql and I can not see where my error is.