Advertisement
hiroyukims

C#.NET - MySQL

Jan 11th, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.74 KB | None | 0 0
  1.         public void Insert()
  2.         {
  3.             string query = "INSERT INTO grou_controlegeral(nome,quantidade,peso,valor)VALUES(@Nome,@Quantidade,@Peso,@Valor)";
  4.             if (this.OpenConnection() == true)
  5.             {
  6.                 MySqlCommand cmd = new MySqlCommand(query, connection);
  7.                 cmd.Parameters.AddWithValue("@Nome",);
  8.                 cmd.Parameters.AddWithValue("@Quantidade",);
  9.                 cmd.Parameters.AddWithValue("@Peso",);
  10.                 cmd.Parameters.AddWithValue("@Valor",);
  11.                cmd.Parameters.AddWithValue("@Data",);
  12.                 cmd.Parameters.AddWithValue("@Comprador",);
  13.                 cmd.ExecuteNonQuery();
  14.                 this.CloseConnection();
  15.             }
  16.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement