Advertisement
Guest User

Untitled

a guest
May 1st, 2016
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.05 KB | None | 0 0
  1. CREATE TABLE `teste`
  2.  
  3. if (incluir)
  4. {
  5. string sqlInsert = "INSERT INTO teste (tes_data, tes_preco) " + "VALUES (STR_TO_DATE(@TesData,'%d/%m/%Y'), @TesPreco)";
  6. MySqlConnection con = new MySqlConnection(conexaoMySQL);
  7. MySqlCommand cmd = new MySqlCommand(sqlInsert, con);
  8. cmd.Parameters.AddWithValue("@TesData", txtTes_Data.Text);
  9. cmd.Parameters.AddWithValue("@TesPreco", txtTes_Preco.Text);
  10. cmd.CommandType = CommandType.Text;
  11. con.Open();
  12. try
  13. {
  14. int i = cmd.ExecuteNonQuery();
  15. if (i > 0) MessageBox.Show("Dado Incluido com Sucesso !!!!");
  16. }
  17. catch (Exception ex)
  18. {
  19. MessageBox.Show("Erro: " + ex.ToString());
  20. }
  21. finally
  22. {
  23. con.Close();
  24. }
  25. }
  26. else
  27. {
  28. string sqlAlterar = "UPDATE teste SET str_to_date(@TesData,'%d/%m/%Y'), tes_preco=@TesPreco WHERE tes_id=@TesId";
  29. MySqlConnection con = new MySqlConnection(conexaoMySQL);
  30. MySqlCommand cmd = new MySqlCommand(sqlAlterar, con);
  31. cmd.Parameters.AddWithValue("@TesId", txtTes_Id.Text);
  32. cmd.Parameters.AddWithValue("@TesData", txtTes_Data.Text);
  33. cmd.Parameters.AddWithValue("@TesPreco", txtTes_Preco.Text);
  34. cmd.CommandType = CommandType.Text;
  35. con.Open();
  36. try
  37. {
  38. int i = cmd.ExecuteNonQuery();
  39. if (i > 0)
  40. MessageBox.Show("Dado Atualizado com Sucesso !!!!");
  41. }
  42. catch (Exception ex)
  43. {
  44. MessageBox.Show("Erro: " + ex.ToString());
  45. }
  46. finally
  47. {
  48. con.Close();
  49. }
  50. }
  51. tsbIncluirTes.Enabled = true;
  52. tsbSalvarTes.Enabled = false;
  53. tsbCancelarTes.Enabled = false;
  54. tsbExcluirTes.Enabled = false;
  55. tstBuscarTesId.Enabled = true;
  56. tsbBuscarTeste.Enabled = true;
  57. txtTes_Data.Enabled = false;
  58. txtTes_Preco.Enabled = false;
  59. txtTes_Id.Text = "";
  60. txtTes_Data.Text = "";
  61. txtTes_Preco.Text = "";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement