Guest User

Untitled

a guest
Sep 17th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. Error in SQL Server CE query parse
  2. UPDATE contas
  3. SET nome = @nome, endereço = @endereco, serv_envio = @envio,
  4. serv_recep = @recep, pass = @pass, user = @user,
  5. tipo = @tipo, Seguro = @seguro
  6. WHERE id = @id
  7.  
  8. command.Parameters.AddWithValue("@nome", tb_nome.Text);
  9. command.Parameters.AddWithValue("@endereco", tb_mail.Text);
  10. command.Parameters.AddWithValue("@envio", tb_envio.Text);
  11. command.Parameters.AddWithValue("@recep", tb_recep.Text);
  12. command.Parameters.AddWithValue("@pass", tb_pass.Text);
  13. command.Parameters.AddWithValue("@user", tb_user.Text);
  14. command.Parameters.AddWithValue("@tipo", cb_tipo.SelectedIndex + 1);
  15. command.Parameters.AddWithValue("@id", idconta);
  16. command.Parameters.AddWithValue("@seguro", seguro);
  17.  
  18. UPDATE contas SET nome=@nome, endereço=@endereco, serv_envio=@envio,
  19. serv_recep=@recep, pass=@pass, [user]=@user, tipo=@tipo, Seguro=@seguro
  20. WHERE id=@id;
Add Comment
Please, Sign In to add comment